AnsweredAssumed Answered

Counting related records

Question asked by Mary78 on Jul 19, 2010
Latest reply on Jul 22, 2010 by Mary78


Counting related records



 I have 2 tables which are related via a Client ID field. They are called Personal Information and Support Visits. Each client has an individaul ID numer (client ID). Clients may have a number of Support Visit records.

When doing a find in Support Visits, e.g., location of supprt visit, I would like to be able to find the number of Clients this might involve.

Is there a way I can have a calculation field in the Supoprt Visits table which will automatically count the number of clients within a particular found set.

Many thanks