Counting

[Greg Hains]

Hi.

A vague title I know. Sorry.

I have two tables. One for a list of clients and one (related by a client ID) for visits to a facility (the visits I cam calling episodes). Every client will have one or more episodes. As clients present with new episodes I want a numeric field in the client table to automatically update with the episode count. Currently I do a Find and count then manually update it, but is proving awkward to do manually as users will jump about screens.

How can I set up a calculation field in the client table to automatically track the number of episodes that client has made.

Thanks in advance.

Greg

[comment]

Try =

Count ( Episodes::ClientID )

---

Another option is to define a summary field in the Episodes table as:

Count of [EpisodeID]

and place this field on a layout of Clients.

Edited December 20, 2010 by comment

[Greg Hains]

Hi Comment.

Once again you have saved my bacon (and sanity).

I'm far from belittling your response and help, but I knew it was a simple thing and yet it escaped me.

Thank you very much, and Merry Christmas to you and yours.

Cheers,

Greg