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
Solved
Membership Yearly History
Best answer by JonathanBowen
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).
+18I 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).
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.