Stephen S Posted December 8, 2006 Share Posted December 8, 2006 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6348 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now