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.