How to delete an related record

C

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 
 
J

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
 
Top