Insert values from form to another database? HELP!

[tmb11152]

hi!!!



I will like to insert some values from a form in database1 to a table in database 2?
how should i do it?

query1 = "INSERT INTO "WHAT SHOULD I PUT HERE"(ID,COURSETITLE,VALIDDURATION,type) SELECT Text1,Text2,Combo1,combo2;"

I dont want to use link tables

thanks a lot

[R_Badger]

A bit of understanding is required here, because what you are trying to do, can be done, but why don't you want to use linked tables, as there is a way to do it but if you dont want to link tables you might not want to do it anyway.