AnsweredAssumed Answered

I have two tables 1) A " Youth " table where there is one youth for each record and another table 2)...

Question asked by Stevehou on Oct 8, 2012
Latest reply on Oct 9, 2012 by philmodjunk

Post

     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.

Outcomes