Sub list for shower invitations
Sub list for shower invitations
(OP)
I am working on a db for a wedding. I have a family table and another for individual family members. A member may me invited to 1 or more parties. Some will be for couples. I may be brain dead but all I can think of is a y/n box for each separate event on the guest table. Suggestions?
Good luck and may God bless.
RE: Sub list for shower invitations
Usually, the best way to implement a many-to-many relationship is to create a table that contains a foreign key for each of the tables in the relationship. In this case, your Invitations table would have the key of the Party table and the key of the Family Member table. The composite of these two keys is the key of your Invitations table. You may want additional columns in it--say, for a meal choice or an RSVP response, which depends on both the party and the family member--but often you won't need any additional columns.
To use the many-to-many table (often called a "join table"), you typically build a query that includes all three tables, with the join table connected by lines to the keys of the other two tables. You can then filter by family member to see the parties to which he/she is invited, or filter by party to see which family members are invited.
Rick Sprague