Is it possible to link one column to another table on the same base? I am creating a database where the common information like company name, the contact person will be same on the logistic table in the same base. When I try to link it links to the 1...

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 informat...