I have a value that I want to do delete everything from a table that contains this value in a field. Also, each one of those that I delete has an ID that is a foreign key value in another table. I ...

Multiple Detail Records - 4 in this case. (linked to the header record) Multiple Inventory Records - again, 4 - (each detail record points to one specific inventory record, but the inventory may be ...