Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Base design - Association

Topic Labels: Base design
136 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi!

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:

  1. 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?

  2. 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?

0 Replies 0