add match field to records retroactively?
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?