Get ready for BLACK FRIDAY shopping starting in

Forums

This topic is locked

Insert record into two tables

Posted 03 Oct 2006 08:16:40
1
has voted
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
Email
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.

Reply to this topic