AnsweredAssumed Answered

Duplicate records in reference table

Question asked by Mzgupta on Feb 28, 2017
Latest reply on Apr 7, 2017 by philmodjunk



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

org-value List.pngorg List View.png

Thank You.