I am designing a database for keeping track of swimming pool participants (swimmers, courses, etc).
I have a table for Household and a table for Persons.
I would like to display a list of Households, with the capability of clicking a display arrow which would then display all the members (Persons) of the household.
I am doing this (sort of) right now by putting a portal in the row with the Household, but I then need to determine the size of the portal. So if I think there will be at most 3 members of the household, and the household has 4 members, then a scrollbar displays on the portal and a member is 'hidden'. Not desirable. If I set the portal to 7 rows, and a majority of households only have 4 members, then the screen has a lot of wasted space. Plus I do not have a way of 'collapsing' Households so I do not see any members unless I ask (click) on the Household to display members.
Is there a way to do what I am asking?