Working on a "membership" database. I want to email all the "chiefs" in charge of each "tribe" all of the demographic information for each member in the tribe.
Originally, I started with a single membership database (all chiefs are members too). To make it easier to think about relationships, I created a second copy of the database that had chiefs in it only. I can relate these two file via the "tribe name".
I'd like to have a field in the chiefs database that contains concatenated information for all the members' info for the tribe that the chief is in. I tried referring to them as repeating fields, but I can't get to anything other than the first and last member in the tribe.
Ultimately, I'll be looking to have FileMaker write an email to the chief's email address and then pop in the contents of this member information field as the body.
The problem is that I can't seem to find any way to grab all of the contents of a portal, or have a calculation field grab all the entries for all the records related.