I have a small database to help me track a series of concerts we are hosting at our home and I am not sure if I have the structure correct here. I have a table called "Attendees" that is a master list of all the people who could potentially be invited, a table called "Event" that contains the date, performer, and the people who actually were invited and are attending. Since there could be multiple people attending multiple concerts I set up a many to many relationship using the table "EventAttendee". Here is where it gets fuzzy for me, I want to be able to pick the attendees for each event off of the master list so I set up a field in Event called "Invited" and made it a lookup link to "AttendeeID" in the Attendee table and shoved in a combo box. Now I'm second guessing myself and getting incorrect data in my query and form attempts. I'm thinking now that I might need to delete the look up because the many to many table will record the data. Is this correct? I have attached a copy of the data base with no data in it for reference.
I know this is a silly little project but it's about the fundamentals for me since I am working on a much larger project at work where I am struggling with the same concepts. I have some experience over the years with database technology beginning with DBase III and then Access 97 up through current but I never tried to design anything using many to many before. I had a coworker who was working on this project with me but she resigned and I freely admit I'm over my head so I figured if I designed this little concert data base and got it working I could apply those concepts to the larger project.
Thanks for any help you can provide me with. Concerts No Data.zip