I am working with a database, recently converted to FM Pro 10, that does Room Scheduling. One of its fields called "Location" which calls from a value list. I had a request to change the item in the value list from EDU Conference to Media Lab. I did the change, but the old data did not change, they still show up under EDU Conference. What is an easy way to modify all, and I have 105255 records that match the location for EDU Conference.
Is there an easy solution to update all records for that field, or I have to go and update one record at a time?
Your help is greatly appreciated.