I have a People table and a Notes table. The People table (IndividualID and FamilyID key fields) has a record for every family member and every family member has multiple note records in the Notes tables. I am attempting a Notes portal that allows me to view the current individual's notes (matching IndividualID), but has the option of a simple button/switch to show the notes from all family members (matching FamilyID).
I've made multiple attempts and seem to be missing something. Any hints?