Hello all.
Could I have an update query to fill in the fields of a table from another one, although the number of records does not match?
I mean, I have the Operators table:
OperName Karla Robert Anna
And the Rooms table:
OperName Room Schedule 405 5:00 23 2:00 234 7:00 123 12:00 423 10:00 345 10:30
How could I have ALL the OperName field at the Rooms table fill in with the operators at the Operators table ONLY and EVENLY?
My Operators table reflects the staff available, and the must be assignated to the rooms on that day.
Thanks in advance.