April 2, 200718 yr 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.
Create an account or sign in to comment