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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
I expect you have a combo box to select an employee and you have duplicate
values in the bound column of your combo box.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I create supervisor hierarchy with the access table 2
INSERT query - please help me. 4
Showing Records from one Table that do not appear in a query from another.. 0
Unable to create the simplest appendy query 2
Tables, Froms, and SQL - Oh My! 2
Link Tables 5
Creating a select query from multiple fields on the same table 2
Store Employee ID in table, Display User Name in form 1

Back
Top