Use triggers to update related table on row modification.

• Create a trigger on the main table to update the related table

• Use the UPDATE statement in the trigger to modify the related table

• Ensure that th...read more

On the Create tab, in the Queries group, click Query Design. Click the Tables tab. Select the table or tables that contain the records that you want to update, click Add, and then click Close.