subsummary from portal

[Jerry]

I have a solution which registers teachers for professional development training. There is a table for the level of training (Algebra I, Geometry II, etc) which is viewed in a portal. So far, so good. The problem: I'm trying to create a subsummary report which tells me how many people are registered for each level. However, the report only summarizes what appears in the first row of the portal. Thus a person who is registered for both Algebra and Geometry only gets counted in the numbers for Algebra, if that is what is listed first. However, he still shows up in a found set for either one. I've searched the forums and Googled it several ways, but can't find an answer--sorry if I'm overlooking the obvious. Any help is appreciated, Thanks.

[dreamingmind]

To solve this kind of problem, I typically write a script that collects all the data into value lists, then steps through accumulating unique categories and totaling the entries. Then the script writes the summary to another field.

SmartPill (http://scodigo.com) has revolutionized this process for me but it can be done in pure FileMaker.

Don

[bcooney]

You should have three tables:

Teachers

Level

Enrollment

The enrollment table is called a "join table" in that it resolves the many-to-many relationship between Teachers and Levels.

On the teachers form view, you have a portal to Enrollment. Here you pick a Level, storing in the Enrollment table the TeacherID and the LevelID.

You would create your subsummary report from the Enrollment table. Sub-summary by Level Name, with a summary field that counts the total number of Level_IDs.

See attached file.

jerry.fp7.zip

[Jerry]

This sounds like what I'm looking for--I'll try it and let you know. Thanks so much!

[Jerry]

Just what I need--thanks a million!!!!