AnsweredAssumed Answered

Count / Summary of how many people signed up - Not in a Report ... Real Time Field

Question asked by Stevehou on Jul 13, 2011
Latest reply on Jul 14, 2011 by philmodjunk

Title

Count / Summary of how many people signed up - Not in a Report ... Real Time Field

Post

I am in FM 11 and have two tables.  One table is called EVENT and has a field called eSerialNumber.

The second table is called YOUTHSIGNEDUP and has a related field called yEventSerialNumber.

Putting the eEventSerialNumber in the yEventSerialNumber creates a new record in the YOUTHSIGNEDUP table.  Some youth sign up for event 123 and others sign up for event abc.  I need to be able to have a real time count of how many youth are signed up for event 123.

A report won't work.  I know how to create a REPORT that does a sub-summary which would tell me how many youth are signed up for each event but I need a real time count / summary of how many youth are signed up for each EVENT.

Why?  I need to know how many youth are signed up for any particular event so i can declare the event full (another calc field) when it reaches a certain number of enrolled youth.

I don't think a counter will work because youth are often removed and my count has to be accurate.

Thank You ... Thank You ... anyone?

Outcomes