Re: Membership Yearly History
Accepted Solutions
I would set this up like this:
A members table:
And a subscriptions table showing the membership subscription for a member/year combination:
You can lookup the membership years on the members table (as shown) or click into the detail of a member’s record to see the years they have subscribed or been a member
By separating out subscriptions and members you can, for example, modify the subscription over time, e.g. membership fees might change by year (if you have fees).
I would set this up like this:
A members table:
And a subscriptions table showing the membership subscription for a member/year combination:
You can lookup the membership years on the members table (as shown) or click into the detail of a member’s record to see the years they have subscribed or been a member
By separating out subscriptions and members you can, for example, modify the subscription over time, e.g. membership fees might change by year (if you have fees).
