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 associated to one person. So I think I have done this part right.
For relationships, EVENTS has a one-to-many relationship with JUNCTION.
PEOPE has a one-to-many relationship with JUNCTION
I created a form with EVENTS as the main form, then a subform of the JUNCTION and inside the junction subform, is a subform of PEOPLE.
When I try to input a new event and person, that data is saved to the EVENTS table and the PEOPLE table, but nothing happens to the JUNCTION table.
Help! What am I doing wrong? Why is the JUNCTION table not populating and how do I fix this!
Thank you so much for the help!!
-Jane
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 associated to one person. So I think I have done this part right.
For relationships, EVENTS has a one-to-many relationship with JUNCTION.
PEOPE has a one-to-many relationship with JUNCTION
I created a form with EVENTS as the main form, then a subform of the JUNCTION and inside the junction subform, is a subform of PEOPLE.
When I try to input a new event and person, that data is saved to the EVENTS table and the PEOPLE table, but nothing happens to the JUNCTION table.
Help! What am I doing wrong? Why is the JUNCTION table not populating and how do I fix this!

Thank you so much for the help!!
-Jane