Membership Yearly History

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).

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.