AnsweredAssumed Answered

Running count of the number of referrals

Question asked by hferrell on Jul 10, 2013
Latest reply on Jul 12, 2013 by hferrell

Title

Running count of the number of referrals

Post

     Help is needed to keep a running count of the number of times an attorney has referred new clients.

     Database has two related layouts: Client Data Entry and Contact Info for Referring Attorney.

     Client Data entry layout has a field “Referring Attorney” where the name of referring attorney is entered.  On the Contact Info for Referring Attorney layout there is a field “number of referrals”.  These two layouts have a relationship; Data entry layout field “referring attorney” (pk) is related to contact info layout field “name” (fk).  I would like for the field “number of referrals” on the Contact Info layout to be populated by the number of times an attorney has made a referral. i.e. Atty. Smith has referred three clients so the “number of referrals” field should post the number 3 because there have been three entries for new clients entered into the client data entry layout. 

     Thanks,

     Hal

Outcomes