Auto Populate new record in Junction Table.

[Deepak.Doddagoudar]

Hello all,
I am having a many to many relationship between table tblMachine, tblMachineSystem, tblMachineSubSystem and tblComponents. I have created junction tables between tblMachine and tblMachineSystem, tblMachineSystem and tblMachineSubSystem and tblMachineSubSystem and tblComponents. I have a multiple Multiselect listboxes in the form. The new record from the form textbox must populate the tblMachine and its ID must populate the junction table a shown below. Now how to write a code (I do not want to go to subforms) for this. In the table, MachineID 2 is the new record.

MachineID	MachineSystemID
1	1
1	2
2	1
2	2

[ssanfu]

Sorry, I am confused about what you are trying to do. I understand you are looking for code to add records to a junction table.
But I am not sure where the data is coming from. You say "junction tables" and "multiple Multiselect listboxes" and textbox..... very confusing.


Could you provide an image of the relationship window and form(s) or the dB.
Or explain again using table names, field names, show data and expected results??

[Deepak.Doddagoudar]

You can see from the form there are four listboxes- Machine, Machine System, Machine Sub System and Components. And a button to for each selection. There is also a text box New Machine on the top right. The data for Drilling Machine is already available in the tables. Now i want to add a new machine to the listbox Machine via text box and link existing items from Machine System, Machine Sub System and Components.
In the beginning when i create the New Machine it is populating to the tables but I want to populate it to the junction table as i showed in the previous message.

[orange]

For those following this thread, this is cross posted at https://access-programmers.co.uk/for...d.php?t=299079

[Deepak.Doddagoudar]

Yeah it is my post. I am keeping my options open and posting it in multiple forums to get a quick suitable answer.

[isladogs]

That's fine ...but you should always state you are cross posting and provide the link in EACH forum.
Otherwise you will irritate forum members and get fewer answers ...not more

[Deepak.Doddagoudar]

Oh.. Okay. I apologize as I did not know about this as I am just two months old in Access.