Assistance needed for “special query” Deleting info in two tables

Hello, I have a site I’m working on now that has many tables. I’m trying to figure out a custom query that would achieve the following:

Two tables – COMPANIES - LOCATIONS

customer_id is the relational link between the two. I have created all of the pages with the Data Assist Wizzard. However when using the company_Delete.php page I also need it to delete all of the locations that are listed under that customer_id in the LOCATIONS table.

Right now this is what code looks like for the DELETE statement.
$WA_Sql = "DELETE FROM `" . $WA_table . "` WHERE " . $deleteParamsObj->sqlWhereClause;

Can anyone help to achieve this

the company ID is passed to the delete behavior using a hidden form element. Take a look at the settings for the delete behavior that is already in place to see what I mean, you will also need to remove the redirect in the delete behavior,

Now add a second delete behavior for the LOCATIONS set it to use the customer_id as the key table and bind that to the same variable used in the first delete behavior.

Okay, thank you for the help! here is what I have done and it seems to have worked.

I looked at the first Delete Behavior and took out the redirect, I then created a new Delete Behavior using the LOCATIONS table and passed the same variable which is the customer_id
I then added the URL redirect onto that second Delete Behavior and then I tried it out and it seems to have worked.

yup, glad to hear it is working.