Yes, but how are your currently tracking this? Need to know whether your current table definitions and relationships can be used for this or if you'll need a structural change first.
These are related through 'groups' that we create
Are these groups, records in a separate, related table? Or via some other way? If a related table, how do you relate a group record to your participants table?
These groups are recorded in a separate, but related, table. They are made up of individual constituents. Individual records are related to groups through group ID numbers. So, individuals can be associated with a group through a reference number that relates them all together.
Does a "group" then represent a family?
Can an individual be a member of more than one group? (Given modern families, this can happen even with families in some situations.)
It can represent a family, a professional affiliation, or whatever group that is useful for keeping track of specific constituents. An individual can be included in several different groups.
As in, groups are just ways of grouping together constituents in whatever way we want. We also have the ability to contextualize the relationship within groups by selecting from a drop down menu: Parent, Sibling, Child, etc.
That makes this a many to many relationship. This is usually managed in FileMaker in this way:
Individuals----<Individual_Group>------Groups (>---- means many to one)
Individuals::IndividualID = Individual_Group::IndividualID
Groups::GroupID = Individual_Group::GroupID
You can define a field in Individual_Group to document an individual's relationship to that group, (Father, Mother, Child, President, Member... etc.)
You can then place a portal to Individual_Group on an Individual layout, adding fields from Groups to the portal as needed and you will get a list of all groups of which that individual is a record. Place this same portal on the Groups layout to list all individuals that are a member of this group.
Well, it seems our database is already fitted to do this. On our contact management page, we have a tab called "related contacts" that acts as a portal to display all individuals within a group, and their relation.
My initial query was referring to displaying all contacts on a table (that can be later exported into an excel file) that includes a column dedicated to displaying relatives, if that individual is associated with a group. I can't seem to be able to make a column that displays this information.
Question: Which group for a given individual? Since an individual can be a member of more than one group. How do you determine which group to list in this column?
This sounds like something you can put together with a List function in a calculation field, but I'm not totally clear on what you want to see here.
List ( RelatedTable::Field ) can produce a list of values drawn from all the related records, so this could list the members of a group.
Substitute ( List ( RelatedTable::Field ) ; ¶ ; ", " ) can turn that list into a single line with each value separated by a comma instead of a return--which may serve to produce the list you need for export to Excel.