Delete a related record

  • Thread starter Thread starter Christopher Poppa
  • Start date Start date
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:)
 
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.
 
Back
Top