2 Replies Latest reply on Jan 11, 2013 6:44 AM by hoffmanjan@umkc.edu

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

    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