A building block to a People List simulation
A recent discussion in the RM Community revealed some anomalies when sorting by the Date of an Event column. That was largely explained there but one finding was that RM's populating of the table or spreadsheet format of People List presented the first added event of the sorted type for each person, regardless of whether there was another event of the same type but marked Primary for that person. That results in potential mismatch between the date year in the People List for Birth and Death and the corresponding Birth Year and Death Year displayed in the Person Preview pane and the sidebar Index. The attached script respects the Primary flag and can be readily edited to change from displaying the first record of the event type to the last. Further queries on its results can be used to present the meaningful information from other database tables.
Uploaded files:thanks for sharing this. Although, I partly understood why the sorting was not as simple and straightforward as it might first seem.