Amiel,
Thankyou for the reply but I am actually looking for a way to change the field to it's corresponding ID in the lookup table. Does that make sense? I have a new database with the text fields in a new table with ID's, and I need to link them in a new table by using these ID's rather than...
I am trying to write an append query to convert data from an old database to a newly constructed one.
I have built the required table with underlying lookup tables for a few fields, and I am trying to import the data, using the fields' viewable column as set to the data from the lookup column to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.