Count Differing Fields

[jbullydawg]

On a course advising layout each course the student has taken is laid out with some characteristics about each course. One of which is whether or a transferring course is a 4 year institution (SR) or Community College (CC).

There are roughly 35 unique fields that capture this info. The user decides for each course whether that course was offered at either a SR or CC by way of a drop-down.

I want to be able to count all of the SRs and CCs but am not sure how to go about that since they span a bunch of fields.

Ex: SRCCElectives1, SRCCElectives2, SRCCElectives3, etc. (there are 35 of these)

Ideally, this calculation would display in Browse Mode but I know how finicky FileMaker is about that.

This report would allow us to determine how many hours came from the 4-year schools and how many from Comm. Colleges without having to count it out by hand.

Any ideas?

[mr_vodka]

You may want to think about going relational here. Anytime you start having multiple fields with the same name, Ex: SRCCElectives1, SRCCElectives2, SRCCElectives3, etc. (there are 35 of these), then its a good time to rethink your structure.

[jbullydawg]

Ok, I'm going to show my newbie-ness here but how would you go about making this a relational situation?

[mr_vodka]

Well you could start with a student table and a choices table. You could also have a courses table should you want to store all the courses instead of in a value list.

You can use a portal to display the choices for each student.