Hi

What is the best way to avoid deleting a record ( a dealer ) from
Table_Dealer
if its key_column is Dealer and this is a non-key column in
Table_Sales.

Ie no delete if the dealer has sales.

Thanks

Rod