AUTOMATION: New record in table2 = checkbox 'checked' in table1?

[AUTORRARI_MAIN]

I need an automation that, when there is a new record received in one table, to check a box with the matching ID in another table.

THE BREAKDOWN:
I have a (unique ID) four-digit “Repair Order” in table1 that, when the balance = $0, sends out a “Cust Survey”. The ‘Survey’ is identified by the same (unique ID) four-digit “Repair Order” number. WORKING PERFECTLY!

I then have the “Survey Results” table, or table2.

When a new set of ‘Survey Results’ are received in table2, we need to locate and match the “(unique ID) four-digit “Repair Order” number in table1 and check the “Survey Received” checkbox in that table.

All the sudden I can’t think of a flow for the automation!?!

I do know that I can’t LINK the tables because there is nothing in table2 to link to… right?

PLEASE HELP ME!!!

DG

[AUTORRARI_MAIN · Accepted solution]

I did it! I solved my own problem!!! YAY is me!

WORKING PERFECTLY! THANKS AIRTABLE!