Membership Template modification

[ladybmj]

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.

Lady

 

[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!

Regards

Jeff Boyce
Microsoft Office/Access MVP