Deleting a record from multiple table

[ajaymansata]

hi
I would like to delete a record based on studid from all the tables which has an entry of that id.
When i create the query i am specifiying all the tables which are involved.
but still while running the query it gives me "specify the tables to delete from."
Why is this error message popping up when i am specifying all the relevant tables?

 

[Ri_ch]

Providing the relationships are defined correctly and you have selected cascade delete you only need to delete the record in the Primary table

 

[darcybaston]

Or create a separate delete query for each table and batch them together in a Macro.

regards,
darcybaston@mac.com