Calculations based on adjacent records
No specific problem yet, this is a proactive inquiry before I stumble down too many cul de sacs.
I have a series of records including geographic locations and I want to calculate a series of paramters including distance, time, velocity based the current and prior record (Record-1). Some databases I've worked with have a hard time referencing information outside the current record, some are more graceful. Is there a straightforward way to reference relative record IDs in Filemaker (I'm still using FM9) or would I need to do something like run a script and cycle through records and hold prior information in variables?