Forums
This topic is locked
Insert record into two tables
03 Oct 2006 08:16:40 sss coder posted:
Hello. Hopefully someone can give me a step by step example. Or even a third party tool (which I will be glad to pay) to do the following. I am using MAC, Dreamweaver 8, VB, ASP, and SQL.I have two tables. From Dreamweaver I can insert into table SCustomer but I can't insert the rest of the text field to the other tables called SSelect.
Scustomer Table:
CID
FirstName
LastName
SSID
SSelect Table:
SSID
CID
Newsletter
If I submit the form the SCustomer table will update with my information and I will get an ID = 1.
In the Sselect table you will see the following of all the newsletters I joined.
SSID | CID | Newsletter
1 | 1 | 7
2 | 1 | 11
3 | 1 | 4
I've looked at the techNotes from Adobe but it's for UltraDev. I'm now looking into a 3rd party tool by WebAssist. I've try looking into that "DR something" site but can't understand it.
If someone can help. I've been searching all day and can't find anything that makes sense. I just need something simple.