How do I to make a logical copy of a table and use it to look up and set a value
I have a table in a new database with 2 fields. Both fields are unique.
Table1 is __pkFieldANumber, FieldBText
I want to display a popup menu using FieldBText and allow the user to select. Using the value in FieldBText, I then need to look up the corresponding __pkFieldANumber.
Can I create another copy of Table1 with a __pkFieldBText and sync the data to Table1?