How do I fix a Look up that is selecting the wrong table?

T

The Real Red

I am creating a work schedule table for my company and linking the employee
list so I can Insert the employee names into the appropriate shift and
location. One one employee (jus the one) every time i select the name it gets
replaced with a nother name. I'm not sure whats going on.
 
D

Duane Hookom

I expect you have a combo box to select an employee and you have duplicate
values in the bound column of your combo box.
 
J

Jeff L

Just an educated guess, but is the record that keeps getting the name
replaced the very first record in your table or query? That would be
due to the fact that your fields on your form are bound to fields in
your table or query and when you update the name on your form, you are
updating the name in your table too. I'm not sure what you are trying
to do, so I don't know how to direct you further without some more
info.
 
Top