value list too big

[Stephen S]

I have a value list (company) that has grown too big and I want to move it to a new table. I didn't know it at the time, but I should have created a separate company with a relationship and a pop-up menu from the project table to the company table.

I know how to create the relationship but how do I move the company data to the new Company table and still keep it connected with each original project record.

I tried auto-enter, calculated result, COMPANY::company = PROJECT::company but it doesn't seem to work across tables.