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.
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.
However these individuals are still reflecting under the “linked to individuals” column. Is there a way to configure it to show only the current individuals?
So if you look at family 92 in these two screenshots, there should only be 2 family members currently (and the look up column to the left in the second screenshot confirms that it is picking this up) but it keeps showing the ‘inactive’ members of the family as well.
I am wondering if I didn’t set the field up incorrectly - I think I might have created the linked field while in the “individuals” tab. So perhaps it can’t filter them correctly?