I have parent and child tables. How to I dele...

I have parent and child tables. How to I delete a parent table row, if there is no entry in child table for that particular parent entry. Fox Example: I have a parent table for Account Heads. The child table is called Transactions. Now If I want to delete one Account Head in Master Table, I need to check in Transactions table, if any entries there related to Accounts Head Table. How can I achieve this?

0 10 408
10 REPLIES 10
Top Labels in this Space