My database has several reference tables where I lookup the correct value for the main data table.
These reference tables also go to make value lists for drop down lists.
The drop down lists have unique values from the reference tables, thus the main database refers to only one record, however the reference table has duplicate records in some cases.
I want to update the reference table, but because of duplicated records, I do no know which record should be updated? How should I merge such that the correct record in the reference table is updated?
Value List Definition Records of the same file