How to delete an related record

  • Thread starter Thread starter chris lee
  • Start date Start date
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 
 
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
 
Back
Top