How to tie together multiple delete queries with the same selection criteria

[JSDART!!]

HI
I have five tables that contain information all connected with a clientID
I want to set up a delete query that will erase all information on a particular client.
I know I can run 5 separate delete queries each asking for a client Id before running.
What I want to do is find a way to run all five deletes but only have to enter the client Id once.

Any Ideas greatly appreciated.
J

 

[Newman]

You should add "On delete cascade" (right click on the relation line) to your relations.