I am building a database and keep a history of the membership for every year. For example look up a member to see if he was a member for the year 2015. so, how do I set this up please. Membership Yearly History
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).
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.