Action to update a record in another table

[Mike_Wrob]

I’m making progress on my inspection app, but am stuck on trying to set up a behavior. I have individual tables for each department where inspections are recorded. I also have a table that lists the departments. In the department table I have a column “Last Inspection”. When a record is added to the inspection table for a department I would like the corresponding “Last Inspection” date updated in the departments table. Is there a way to do this?