how to create a delete query?

[chan0210]

Hi.

I have three tables. Each link together by relationship. In a form, i will display the relevant data from these three tables by means of a query. However, i realised that i could not perform a delete operation as my database table still exist the particular data even if it is deleted from the query.
How do i create a delete query so that it will also automatically delete all the datas from the 3 table?

Please help.

 

[Ron_dK]

If you want to delete your records in your table, make sure that the relationships are set to : Enforce referential integrity and click the checkbox :
Cascade delete related records.

Hth