Update query between two tables troubles?

[Celx]

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!

[June7]

How will the query know which records get which value? Is there a common ID field in these two tables? Join the tables on the common ID. This will allow the value of record in one table to update the value of corresponding record in other table.

Show complete SQL statement for analysis.

Why do you have two tables anyway?