Delete from multiple tables

[conceptmgt]

Hi

How can I delete from 3 tables in an access database, I can delete from table 1 and table 2 but I don't know how to delete from table 3 ast there is no relating field in table 1 and 3. Tables below:

TABLE1
customerid
firstName
Surname

TABLE2
bookingid
customerid
datebooked

TABLE3
weekBookedid
bookingid
statusid

Thanks

Gary

 

[Targol]

Either you set your foreign keys constraints to "On delete cascade" in your DB. This'll delete all the related rows in child tables when deleting in master table. Or you do 3 DELETE queries. Water is not bad as long as it stays out human body ;-)