Folks,
Please help me to fix this issue since I am very new to access database. I have a master table called “Justified” and I have an imported table called “ALL JOBS”, now I want to update the master table ”Justified” with some partial fields from imported table.
I want to update the Fields “Plant” to “MethodStatement” from “ALL JOBS” table to “Justified” table, and also I want to add new record if any found in “ALL JOB”.
NOTE : Field called “SDJobNo” is the matching field.
I have attached the Database and picture of what I am trying to accomplish.
Thanks in advance,
Joshi