I am assuming that no student will have more than one plans record with "current" status.
This would not be a field with global storage.
Define a calculation field, constCurrent, with text as the result type. Enter this expression for the calculation:
Define this relationship:
Students::constCurrent = Plans|Current::Status
Plans|Current would be a new Tutorial: What are Table Occurrences? of Plans.
Then there are two ways to use this relationship to get the count of current plans:
Define a calculation field in Students as:
Count ( Plans|Current::Status )
Define a summary field that computes the "count of" status in the plans.
Put either field on your students layout to get the count of completed plans records.
Actually, each student can have multiple plans, some current, some completed.
And you want a count of how many students have at least one plan record with status = "current"?
Then Count ( Students2::StudentID ) -->count any field in students where the field is never empty.
will count the number of students that meet that criteria. Students2 would be a second occurrence of Students.
Without the added occurrences and relationships, you can also get the same count with just your original relationship:
If you performed a find on Students where you specified "current" in the Plans::Status field on the same layout.
Thanks Phil. Worked like a charm!