Inserting data into two seperate tables with Dreamweaver

[lutzlut896]

I am trying to find out how you to insert the unique ID from one table into
another table so that those two tables become connected. In other words the
user is signing up to the site with one form, so the unique ID is being created
in the members table, but after the user signs up to the site he/she also needs
to be able to add their products to the site, and I need that unique ID from
the members table to be inserted into the products table so that those two
tables can be connected. But I'm not sure how to do this, I know that I can't
use a form, or so I don't think, because the user won't know what their unique
ID is, because the database is creating that. Any help with this would be
great.

Thanks,

Jonathan

[delaneypub]

Depending on the programming language you are using and the database, you can
either return the value of the primary key of the members table to the query
(in Coldfusion, it would come back to the returnvariable in the query). Or, you
can do another query immediately to read the last record in the members table,
presuming that's the one you just added. Then, the primary key to the members
table can be set up as a foreign key in the products table.