strSQL

//Using Visual Basic 6.0
//SQL Server 2000

Hello,

I need LOTS of help in the area of my SQL code.
Basically, I need my control2 to update joined tables in my DB.

//DB structure:
table1.elID (PK)
table2.mID (PK)
table3.asID(PK), table3.elID(FK), table3.mID(FK)

Ok, with control1 a new elID in INSERTED into table1.

control2: //Here we go

Table2 holds mID's that will be assigned to table1.elID. As a result of this assignment, table3 will be UPDATED with a new asID for each assignment of table1.elID to table2.mID. I hope this is making sense. The ONLY table being UPDATED here is Table3.

Now, I have a list box holding 200 mID's that I want assigned to a particular elID, (let's call it elID 105).
End result, my table3 should contain 200 DISTINCT asID's, the 200 mID's from listbox, and 1 elID.

Can someone show me how this code is suppose to look?

Thank you kindly!

Typically you'd update each table individually. Recordsets created by joins are not often updateable.