insert form data into joined tables...

[createmedia]

Hello All,

I am trying to insert form data in to two joined tables. If Table 1 has a
"ProductID" unique key and Table 2 has a numeric "ProductID" field..... (the
joined field) ....how can I insert a form submission into the 2 tables..?

Thanks so much for any help you can give...... I'm starting to drink heavily
on this one :-)
So far, this is the basic structure.... but obviously does not work for the
joined tables ...

THANKS!!!

<CFQUERY name="Testing" datasource=" ">
INSERT INTO Table1(data,data1)
VALUES ('#form.data#','#form.data1#')
</CFQUERY>

<CFQUERY name="Testing2" datasource=" ">
INSERT INTO Table2(data,data1)
VALUES ('#form.data2#','#form.data3#')
</CFQUERY>

[Dan Bracuk]

You need to get the new productid from the first table. There are lots of ways to do this. What db are you using?

[createmedia]

I'm using MS Access on the server...
thanks...