Everytime i create a listbox, It stores the ID# and not the name.e.g. I have employees that I am tracking and have a combo box based of a select group of employees (Department) but when I go into the table and look at the field they are stored at, All I see is ID#s. anyway to get it to show the names?
Reply from Alex Hedley:
The first field in your data source will be the one that is stored in your Table. You can just use a Query to JOIN on the ID and show the related name.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 8.
