December 20, 201015 yr 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
December 20, 201015 yr 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, 201015 yr by comment
December 20, 201015 yr Author 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
Create an account or sign in to comment