Relationship within a fill out table

[Annnnn]

I hope this is the correct place to ask this question..


I have an existing Excel sheet that I want to import into a new access database, but there is one column with names from companies that I would like to have in a dropdown menu.
When I tried some stuff within access I created a new table with these names and created a relation between my Main table and the tblCompany. I really liked this because now also in the tblCompany I was able to see how many orders are listed under the specific company.
But when I import the data from Excel I am not able to create this relation because then the data from my Company field is removed by access.
Is there any possibility to add relations in an already filled out database?

Or that there is an easy way to insert the company name in the main table again based upon a value of a different field

Tnx!

[Annnnn]

oooow made a stupid mistake with the primary key fixed it

[pbaldy]

Thanks for updating the thread. I'll mark it solved.