I want to find a way to hide Access Identity values in a form without the use of subdata sheets.
In the form shown below there is a column called Status ID that holds a integer value that
relates to another column called Status. These two columns are in the "Order Details Status"
I would like the user to rather see one column with the words (eg "Allocated", "On Order" etc)
and make there selection in any row of that column. Is there a way to achieve this without the use of subdata sheets?
For example can you use a query as the source of the form?