Column values for related tables

I have 2 tables that are related by Referencing the “Dealership Name” Table 2 is a form that needs to be completed when the Dealership is visited. I need the column ‘Visited’ In table 1 to add the value "Yes’ to the correct dealership when the data is input in column “Visit Complete” in table 2.
Is there a way to do this?

0 15 800
15 REPLIES 15
Top Labels in this Space