This might be a ridiculously simple question but here goes anyway. I understand HOW to address Many to Many relationships in Access. I don't have a problem creating a third table with the one to many relationships to both parent tables. This I get. What I'm struggling with is how to enter data INTO the tables. I'm not sure if the junction table merely acts as a tool to join the other tables or if when I (or anyone else for that matter) enters data into which tables they have to enter data.
Do users have to enter data into all three tables? or does entering data into the to parent tables update the third (junction) table automatically? This is really causing some confusion for me when I'm designing forms because I'm not sure where data is to be entered. Is the junction table used at all in data entry? Do you need to enter duplicate data from both of the parent tables AND the junction table? Any clarification would be extremely helpful.
Thank you!