Membership Template modification



I need help in modifying or adding fields to the membership form (template)
to include the names of individual and or family members of persons who
purchased family membership. This could include up to three additional names
under one membership.

However, when I get ready to print the renewal invoice, I only want to
include the paying member's name. Can you also tell me what I would do in
this case also.

Thanks in advance for your help.




Jeff Boyce

If you are trying to add (up to) three additional names on a table,
something co-members, you may want to rethink this approach.

What if someone decides 3 instead of 4? Or 5 instead of 4? Those kind of
changes would require a major maintenance effort on your table, your
queries, your forms, your reports, your code, etc.

Instead, it sounds like a "membership" can have 1-to-many (in your current
situation, 4) members. This would require a new table to store
[MembershipID], and [MemberID].

Notice that I didn't store "names" in that table. That's because I'm
assuming you already have a table of persons ... and you'd use a person's ID
as the [MemberID]! No need to store duplicate data.

Good Luck!


Jeff Boyce
Microsoft Office/Access MVP

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question