calculations dependent on fields in other records
I have a cumulative counting task having to do with multiple records.
It's a timecode thing from editing but in essence...
imagine three records
I need to be able to have a "timecode start" field in Record C that takes its value from the "timecode end" field in Record B. In turn, the "timecode start" field of record B needs to take its value from the "timecode end" field in Record A.
And, depending on how the fields are sorted, whichever record is first (in this case Record A), I need the field to know that it's the first in the list and to accept a global value.
I hope that's clear enough.