paste values from one table to another table in form

[mukky]

Hello,



please can you help me ?

i need insert values from table tbl_parts (column 1,2,3...) to tbl_materials - in tbl_materials is primary key. the values will be inserted if form is on load

1 Table tbl_materials
columns
MainID, MatID, PN, Desc, Suplier, quantity

2 Table tbl_parts(lines are filled)
MatID, PN, Desc, Suplier, quantity

i have this code, but i dont know define primary key, and access say error Run-time 3075

DoCmd.RunSQL "INSERT INTO tbl_materials (MatID, PN) SELECT (MatID, PN) FROM tbl_parts"

i need insert to field "quantity" for each record another values

thank you for help

if you understand something to write
sorry for my English

[pkstormy]

I'm more of an ADO versus DAO coder (and like to work with queries in design view) but what I might do is design the update query itself and save it (ie. qryUpdateMyRecs) making sure it updates the appropriate recs with the criteria I wanted.

and then in code you could just run the query...

docmd.openquery "qryUpdateMyRecs"

or once you design the query in the designer, change it to SQL view and then copy/paste the syntax in your code (you may have to remove a couple of ")

[KathyL]

From your post, we can’t tell some things. When you are trying to update/or/insert data into your 2nd table, we can’t know if the record already exists in your 2nd table. You might want to take that into consideration. My approach, would be to consider a regular access query which could be executed, which would do the update of table 2.

The other thing is, if you are designing a relational database, why are you replicating the same information by MatID into a 2nd table? It seems like you would just want to access the original information in table 1 and not replicate data.