AnsweredAssumed Answered

calculations dependent on fields in other records

Question asked by ijontichy on Jan 9, 2009
Latest reply on Jan 13, 2009 by ijontichy

Title

calculations dependent on fields in other records

Post

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

A

B

C

 

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.

Outcomes