Multiple records - find latest
I have a database with 188,000 rows. Each record includes a person's ID number and a year in which the record was recorded (along with 50 or so other fields).
Example of a person with 3 records:
A person could have just one record. A person could have 1 to 10 records since this database covered 10 years. I need to pull one record per person containing the latest year. In the above example, the record for 2003 would be marked or extracted.
I'm racking my brain trying to figure this out. I tried some scripting with setting a variable for the id and year and then looking at the next r ecord and comparing. But I ended up not exactly sure of the logic I was creating.
Use Go To Related Records or a scripted find to pull up all records for a given ID. Then SORT your records by the year field. This will make the desired record either the first or last record in the found set depending on whether you sort ascending or descending.