Move value list to new table

[Stephen S]

I have a value list on the current table that has become too large, so I have transferred the list to a separate table with each item being an individual record. I have set up a relationship between the two tables and a drop-down list that can access this table.

My problem is that I wish to retain the existing data from that value list for the current records but be able to utilize the new method for new records and perhaps even change previous ones.

Unfortunately changing the field drop-down list from the old value list to the new one causes the old data to disappear.