This is one of the functions of a Foreign Key Constraint. It will verify that the FK is not used in the related table before allowing the row to be deleted.
>How would I use a Foreign Key to prevent deletions on the parent table?
>
>For example, I have an Orders table and an OrderCancels table related by a FK on the iOrdID. When the app requests to delete a record on the Orders table, I need to check the OrderCancels table via the iOrdID FK for corresponding records, and if there are, not delete the order.