I have two tables 1) A "Youth" table where there is one youth for each record and another table 2) "Event Youth List" (EYL) where each youth may show up many times as scheduled for an event. The two tables are related by the Youth Number.
(With the guidance of Phil - Thank YOU!) I have a count field in EYL (sCount) which (with a filter) counts how many times the youth "Did not attend" an event. The sCount field from EYL is placed in a portal on the Youth record so I only get the count for that one related record - that one youth..
What it does: If a Youth "Did not attend" an event, his number of failures (sCount) shows in the portal placed on the Youth record.
Problem: I need the number of failure results (sCount) to also show on the EYL table for that youth. The people who input attendance data only work in the EYL table.