Column2 data from lookup table in query instead of Column1 index key

[riggsd]

When running a query to export as a table using Make Table, how do I get the actual record value from column1 of the lookup tables rather than the index key from column0?

I think I've done this before but it was too long ago.

Edited to fix column numbers in text but can't fix in title.

 

[alansidman]

Link your lookup table to your primary table and bring in the column1 value to your make table query. Uncheck the box in the query which has the index value so it does not appear.

 

[riggsd]

Thank you. That helped.