Get totals from related field and assign level of participation
I am currently working on a db for clients. I have an Intake table that relates to a Contact table. What I have been banging my head into a wall over is how to create a count of contacts for each client and then assign them a level of service based upon participation in the last three months. I know I must be missing some very key concept but I'm not sure what. Any advice on how to start this?