We’re in the process of designing our base, and we manage an association where businesses have multiple employees within each membership. I’m trying to design a base to keep track of event attendance, event registration, membership (which is paid for under the business), lunch orders etc.
Having trouble deciding:
Do I setup my base with each contact as the primary field? Or should it be the primary membership holder as the primary and their affiliates listed in separate columns within the primary membership row?
I’m thinking of having my event information (registration, budget, tasks) in a separate base so its easier to view and filter. We hold about 2-3 events per month. But this information (attendance and registration) will be a column in the main membership base.
3)Also we hold events at 3 different locations, would it be detrimental to have a base per location?