relational records cann delete - how to catch the error

hi all
i have a table related with another table probably master and tranasaction. when user tryies to delete a record in the master it has to indicate that the record is related or exists in a trasactional table. is it possible to check without checking the transaction table. replies and help will be appreciated
thanks
parthi

parthi_75


Use Relationships. This is what relational databases are for. If you try to delete the master while transactions exist you will get an error. Trap the error and do what you need to do.