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