Running count of the number of referrals
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.