Is this for a layout based on your Event table?
If so, you can do one of two things:
Take that summary field defined in YouthSignedUp that you would have used in your report and place it on your event layout. That's all you need.
If you are using a portal on this layout to sign people up for your event, the summary field may not update smoothly without using a script trigger on the portal fields to refresh the window. You may find you like the results better if you define a calculation field in Events with this expression to give you your count of signed up youth:
Count ( YouthSignedUp::yEvenSerialNumber )
Wow! Wow! Wow! Thank you so very very much!!! I preferred your second method. I have two things to say:
1) How brilliantly anticipatory of you to anticipate my results would go on the Event table and how remarkable for you to anticipate the event table being in a Portal - it was. Wow!
2) I put the formula in and it counts perfectly but I need to like leave that layout and come back before it recalculates the total. I have a script that refreshes the window but that didn't force a recalculation. Any quick fix???
The second method--using a calculation field with sum should not need a refresh window step. You do need to commit the changes to the current portal record before it updates, but that should happen the instant you exit the portal such as to "leave the layout and come back". So I'm not sure I have a clear picture of the problem here.
Nor do I see why you need to leave and come back before it recalculates.
Yeah it does require a "commit". If I push ENTER on the numberic keypad the number updates properly.
My EVENT table has the calculation field : (Unstored) from YouthSignedUp, =Count(YouthSignedUp::yEventSerialNumber)
You may find it helpful to add a script trigger where appropriate to run a one line script to commit the record so that the calculation updates.