Junction Tables

[jk42]

Hi Again!

I've have been googling this question for awhile now, and I still can't find a clear answer. When you have junction tables for your many to many relationships, do you put the data into that table? Or just in the two tables that are joined to the junction table? If you don't enter the information into the junction table, how does it get in there. Sincere apologies if I sound like a moron. All of the things I have found on the web don't address how the data got into the junction table.

 

[boblarson]

You put data into that table usually by using a subform on a parent form. You find the side where it will be the "one" so to speak and then one side will be a subform and you would use combo boxes to select the data for one of the fields. The parent form would already have the one side chosen and the Master/Child link between the parent form and subform will automatically enter the ID from the master (parent form) into the child table and you just have to choose the associated value.

I hope that isn't too confusing.

In fact, here's a sample I have which shows how it is done:
http://downloads.btabdevelopment.com/Samples/forms/SAMPLE-SimpleMockupOfJunctionTableAndForm.zip

 

[jk42]

Oh ok. Thanks! I will definitely check out that sample. Would this process still work the same way if Importing all of the data into Access from Excel? I just read that the easiest way to do that if you're new is to use the wizard, but would I then do these above steps later? or is Access smart enough to see that I will need junction tables?