I have 2 tables with the same field names. How can I produce a query update that copies 3 fields from table 1 to table 2 if a if a match is detected in 3 other fields?
Here are the fields that need to match in order for the other 3 fields to be copied:
Fields: (in both tables)
Atnum, Subnum & Patnum
Only 1 field needs to match.
If a match is detected, copy table one fields (all 3 fields) to table 2 fields:
ib, ibq & com