I am trying to connect a few colums from one table to another table. Can this be done? Every time I do link to another record it links to the 1st colum. Which is not ideal. I would like to lookup so if I update one table it populate the same information to another table. Please help.