AnsweredAssumed Answered

Calculations based on adjacent records

Question asked by troyecol on Jul 6, 2009
Latest reply on Jul 6, 2009 by troyecol


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?