Hi, I have 2 tables “Jobs” (Parent), and “Allocated Jobs” (Child). They are linked via the [Job Ref] column which is the key in the “Jobs” table. I need a way to update the [Job Status] column in the “Jobs” table to the [Job Status]=“Completed” when all rows for the current record show completed in the “Allocated Jobs” table. I hope that makes some sense!!?
Thanks in advance