Identifying most recent versus less recent related records in Filemaker Pro 9
I want to able to go through related records in a table and identify which one is the current version and which ones are older (stale) versions, so they can be marked as active versus archived. For example, I have a People table with records on individuals, each person with a unique PersonID. A given person may have multiple records, however, reflecting changes in position, organization etc over time. I would like to have a script that would go through the file, sort the records by PersonID and date (I know how to do that much) and then mark the most current record for each PersonID as “active” and the other records as “archive”.