Thank you all for your replies!

I have attached snap shots of the steps that I am trying to carry out.

In 1, shows a table with a column labelled "Information" that contains values looked up from a User Info table

2, shows the lookup logic definition

3, shows the way the same table with a column labelled "Information" values are stored in SQL server when importing table from MS access to SQL server (int6 is the header for "Information" column in SQL server)

The "Information" column is just one of the many columns that I have to import to SQL server so replicating the join logic for each columns is not feasible at the moment. Is there any other way to store these looked up values in Ms Access so that when I write this data back I can see the labels instead of the ids?

Regards,

Mathews