Delete a related record

C

Christopher Poppa

Is it possible to delete a related recoed using a command
button? i have created a database which has 4 tables,
Customer, orders, products and order/product link i want
to be able to delete customers but the customer may have
an order so this will not allow me to delete the record
unil the order is deleted. many thanks chris:)
 
M

Mike Painter

Your tables can be set to delete all records associated with a given record.
However to delete the customer and just one order would require one or more
delete queries, one for the orders and one for the order items assuming they
can buy more than one thing at a time.
 

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

Top