How to delete an related record

[chris lee]

My database has four tables, customer, products, orders
and order/product link. Is it possible to delete a
customer with a command button, I have tried a few
different ways but because the customer may have an order
the database will not allow the record to be deleted.

Many Thanx
Cris 

 

[Jonathan Parminter]

Hi Chris,
use the relationships layout window to edit the join
between tables so that, in addition to enforcing
relational integrity, you also enable cascade deletion.

Luck
Jonathan