How to view/amend Lookup Values in Access 2016

naa123

New member
Local time
Today, 07:17
Joined
Oct 30, 2023
Messages
20
Hi,

I have lookup fields in my tables and each lookup option has a number assigned to it (e.g. No = 0, Yes = 1 Not Sure = 2). How can I view/amend the number assigned to each lookup option in my table? When I click Modify Lookups, I can only see the text value and not the number that is assigned to it.

Thanks!
 
see the Table refered by the Lookup and modify that table.
if there is no Table, then it is only a List of 0,1,2
 

Users who are viewing this thread

Back
Top Bottom