How to find child records is exists before to delete parent records.
605989Oct 27 2011 — edited Oct 27 2011Dear Everyone,
I would like to ask you, is there any simple way to find child records is exists before to delete parent records.
I have a master table defined primary key and I have referenced that as foreign key in many tables.
I have used Delete_Record to delete but it isn't display the message 'child record exist' but it cleared the record from the form. So I need to know how to find child records is exists or not before to do delete_record so that I can display message in-case it exists.
I do know we can able to check in every table matching the column manually, but what if we use 100 of tables then it is not possible to check manually.
I am sure there must be simple way to find as how the oracle identifies when we execute delete query.
Please help me on this.
Thanks in advance.