Delete a related record

[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

 

[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.