Access display text in a field that holds an ID

Hi. In Access I have a field called "Status ID" in a table called "Sales Order Details". I used the Lookup wizard to
link the field to another table called "Sales Order Details Status", which has an ID column and a "Status" column.
At the moment a user selects an item and it shows the ID in the field. Is it possible to display the "Status" but hold the ID?

1
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
PatHartmanCommented:
In the combo's properties, Set the column widths properties.  0 hides a column.  So set the first column width to 0.  Make sure the RowSource is sorted by the text field to ensure that it works correctly.  The combo will show the second column which looks like the text you want to see an hide the first column which is the ID field.  The Bound column which should be 1 indicates what will be saved.  So as long as the bound column is 1, the ID is what will get saved.
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks
0
 
PatHartmanCommented:
You're welcome
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.