EDIT: It’s not letting me upload pictures, anyone know why?
I have 2 tables. 1 called Members and 1 called Appointments.
Here’s the members table:
Each member has a Name, Membership Type, Shared with (linked to existing table), and another column linked to ‘appointments’ table.
Here’s the Appointments table:
You’ll notice a the field “Total Appointments per Active Member”
Anyone that has membership type ‘shared’ means that I don’t count them as an actual member. I want to link them to the original member. And since I want to track each appointment by the main member, I’d like to figure out how to add the members ‘shared’ total with the existing membership.
E.g. John Smith has a total of 3 appointments (his 2 booked, and 1 from his shared member Jenny). How would I do this?