Update related records
I am working on a database that I use to keep track of any jobs we work on, equipment that's used, etc. I assign a job # that is related to fields in other tables. If I change the job # is one table, the records do not update in the other tables.
How can I get the records to update if the job # is changed?