Count of one field in relation to another

[blueyz]

I have a table called subject and it contains subject code and series number. I need to create a calculation called count which is the number of subjects the series appears in. How would I calculate that?

[bcooney]

Each subject has just one and only one Series, right? If not, you need a third table which would hold all possible combos of Subject and Series--a join table it's called.

If not, your calc is from the Series table =

count (Series to Subject::SeriesNumber)