Count of specific data selected in a field

[Tarheelfan]

I have a relational database called Graduate Applicant Status. In it I have a pull down field listing available graduate programs, which pulls the appropriate program code from another database. My question is, without doing a find for each program (there are approx. 55) and counting manually, is there a way do to a count based on what info is selected from the pull down menu?

Any help would be appreciated.

[CyborgSam]

1) Define a global, g.PullDownValue to match the field with the program code (I'll call it ProgramCode).

2) Define a relationship between g.PullDownValue and ProgramCode, I'll call it CountRel:

g.PullDownValue::ProgramCode

3) Make a calculation field c.ProgramCode.Count with Count(CountRel::ProgramCode)

4) Set g.PullDownValue & the calc field will show the count!

You can design this so that the counts for all individual programs are always available. Let us know if you want to try that (it's more complex...).