I have imported my Acccess Database into Analytics. The tables are connected using Lookup Column which is linked to the ID. 

e.g. I have a table called 'Inspector' and 'Company'. The lookup column in 'Inspector' looksup the Company ID. However that is a number and is meaningless unless I know the name. 

Is there a way to lookup the ID, but display the name, like we can do in Access.

The difficulty is that to update the 'Inspector' table, I need to find the Company ID first from 'Company' to enter a new Inspector. 

Best regards,

Sony