Recent content by Wyldhare

Thank you Craig for the additional input, it was really helpful. Sometimes just hearing the same information in someone elses words can be a huge help. I am back at work today, so I hope to take all this combined info and make another stab at this thing! I really appreciate your time and...

Okay, so my user is going to have to: 1. Go to the EVENT form and input the event information 2. Go to the PEOPLE form and input the info on each person who attended. 3. Then, go to the JUNCTION form and using a pair of combo boxes, tie the PEOPLE and EVENT to each other, as appropriate It is...

Oh actually that made more than a few lightbulbs turn on! Thank you! I will go back and beat on this some more. Thank you again and I hope you have a wonderful weekend!

Thank you Paul. I think I will have to read up on Combos, I have not done anything with them yet. I suspect once I understand them, I will understand what you are suggesting. I think you are suggesting EVENTS as main form, with PEOPLE as subform of EVENTS. Then, make JUNCTION a subform of...

So PEOPLE should be a subform of EVENTS and I just leave out JUNCTION? If so, then how does JUNCTION get populated? And yes, I don't have a control binding JUNCTION and PEOPLE. I hope I don't sound like a complete newbie, but I pretty much am! Again, thank you for your guidance! -Jane

Hello, I am fairly new to all this and I am trying to create a database in Access 2003. I have three tables: EVENTS - Primary Key EVENT_ID PEOPLE- Primary Key PERSON_ID JUNCTION - Primary Keys EVENT_ID & PERSON_ID I can have many people associated to one event. And I can have many events...