Calculate from Current Context?
I'm designing a filemaker database for a study involving scuba divers. I've attached an example of the data entry layout and relationship structure.
Ideally, I'd like to be able to enter data for all Divers on a team from one page as seen on the left. The Divers might reconfigure into a new team throughout the study, so that is why the data entry layout is at the top level table: groups.
On a given Groups record, I would like to define the Diver, and then enter log information for each member of the team in different portals.
I structured the Divelog relationships as instanced versions of a single Divelog table because I would like the data from ALL Divelog Records to be recorded onto a single Divelog table that is exportable for later analysis in Excel. I would like to create a calculation field that autofills info into the Divelog Table for any fields that live at the Diver and Group Level.
The problem I'm running into....at the Divelog level, I created a calculation field to fill in the grandparent Team Name. It only works for the first Diver Table instance because the calculation is starting from the context of Divelog 1. You can see the group name missing for Anna Coral on the right side of the screenshot.
Is there a way to calculate from the current instance? So fields on Divelog 2 would calculate from the context of the Divelog 2 Instance?
Any suggestions on how I could better structure my tables would be much appreciated. Thanks!