AnsweredAssumed Answered

add match field to records retroactively?

Question asked by AEH on Nov 14, 2012
Latest reply on Nov 16, 2012 by philmodjunk

Title

add match field to records retroactively?

Post

     In FM Pro 10, the match field we use to connect most tables is the "PersonID".  One table was created without the PersonID field, and connected via another field (ApplicationID).  After many records were entered, we realized that in order to make the information accessible through other tables, it needed to be connected via the PersonID.  But after this connection is made,  the PersonID field is empty for the records which were entered previously.  Is there a way to make the PersonID field retroactively populate with the correct matching ID number for these records?

      

Outcomes