AnsweredAssumed Answered

How do I to make a logical copy of a table and use it to look up and set a value

Question asked by hoffmanjan@umkc.edu on Jan 10, 2013
Latest reply on Jan 11, 2013 by hoffmanjan@umkc.edu

Title

How do I to make a logical copy of a table and use it to look up and set a value

Post

     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?

     Thx

     JanH 

Outcomes