I want to know is there any way to know whether a record is in use with other records. Is there any way to find it other than, by catching referential integrity exception?I generally catch this exception and tell users no to delete or unable to delete the record.