I have an access database that is used to manage the members of a sporting club, although at the moment it is pretty basic.
All members pay an annual membership, plus they may also have extras, such as locker hire. There are different types of membership (Full, Junior, Life etc.). What I want to be able to do is generate invoices, then record payments as they come in, and make a list of outstanding memberships. Basically I am after advice as to the best way to handle all of this. At the moment I have a table that contains all the member’s details, another that has all the membership fees, but that’s about it. I am pretty new to access (I really don’t even know where to store the calculated annual fee!), so please use little words!