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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete a related record 1
How to delete a related record 3
Auto populate fields in new form 5
Launching a Form to Another Form to Create a New Record 11
Creating a New Record for Another Form 2
Form design to add data to 3 tables in "Order Entry" style db 1
postion subform to last record after adding 2
Locked Subform still lets me delete a record 2

Top