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?