How do I calculate based on different fields in two different related records?
Greetings! So I have a table with measurements on frog calls, and a related table of notes measurements. Each call has two or more notes. I need to calculate internote intervals. So in the call layout I want a calculation fieldd that will look at notes for that call and...subtract the value in the 'end time' field for the second to last note (note for which 'unit category' field contains "2l") from the value in the 'begin time' field for the last note (unit category = "ln"). Help!