Related Tables

Question

How to I know wether or not a record from a Table is related with others Tables. If the user want to delete a record from a teble and it's related with otrhers records I want to display a warning message, otherwise just delete it. What can I do. Thanking in advance. Carlos