Insert into 2 database tables
Is there an extension that I can use that will insert / update 2 tables in my database?
Natively dreamweaver is quite easy to use when inserting to a database; select the table you want to insert into, select the form elements and which columns in that table and it writes the rest for you. However it does not allow you to have 2 inserts on the same form, and so I can't get it to populate 2 tables in my database.
In my case I have a form which populates a user table, and a dependant form (which also populates the user table) but in addition needs to write to a link table to store the relationship between the user and the dependant.
help?
Comments
trying to help
Hello!
You want to write in two tables at the same time, OR... to write in 2 separate tables passing de IDKEY of the primary table to make a relationship with the SECOND table?
I use a little thing since ever, a passit to a second page where it performs a INSERT TO command for the second table. I retrive the data or the IDKEY only by a recordset using order DESC selecting the last one inserted, in case of several users i make a field in the inserting table where in records always the username and a timestamp, so when i make the recordset i use the DESC and WHERE USERNAME LIKE.
I know it sounds complicated due this "not so good" explanation, sorry for my bad english!
hope it helps you, somehow.
A. Amaral
ImpAKT
You must me logged in to write a comment.