Hello,
So I have two tables, one that is for the receptionist, and one for the administration side of the company I work for.
I created a query that was supposed to pull in information from the receptionist table fields and update the same fields in the administrator table.
Currently it does update the desired fields; however only with one variable for each row.
So say I have two rows in the meat variety field of the receptionist table:
- Cat meat.
- Dog meat.
And in the meat variety field of the administrator table I have these two values:
- Turtle meat.
- Rat meat.
Upon running the update query; I get this result in the meat variety field of my administrator table:
- Cat meat.
- Cat meat.
So while the update query does change the value of my meat field in the administrator table, it only will change the previous values to one value instead of reflecting the two different values in each row of my receptionist table. The values are selected from a drop down menu, could this somehow be affecting the query?
This is what I have in place in my update query:
Field: MeatVariety
Table: Administrator Table
Update to: [Receptionist Table].[MeatVariety]
Criteria:
or:
Any help would be appreciated!