I have a base set up for the families that we support through our feeding programme. There is a tab for individuals, giving details about each person, and a tab for families, where the info common to each family is held. On the families tab, I also have a “link to individuals” column, where the base automatically lists the names of all the individuals in the household.
Using that list the base then calculates, still in the families tab, information like how many individuals are in a household, how many of those individuals are children, etc.
As we are updating our database we have found that some individuals have left the household. I would ideally like to keep their information on record, rather than deleting them. So I have created a “active/inactive” single select column for each person, under the individuals tab.
The question is, how can I configure my linked column on the families tab, such that it only picks up active individuals in each family?
I hope that makes sense. I can post screenshots if needed.