Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Sub list for shower invitations

Sub list for shower invitations

Sub list for shower invitations

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

You have a many-to-many relationship there. A family member may be invited to multiple parties, and a party hosts multiple family members.

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close