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
Page 1 / 1
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).
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.