AnsweredAssumed Answered

Identifying most recent versus less recent related records in Filemaker Pro 9

Question asked by keswick on Oct 7, 2008
Latest reply on Apr 14, 2011 by matthijsbeekman

Title

Identifying most recent versus less recent related records in Filemaker Pro 9

Post

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”.

Outcomes