You have to construct an insert statement for each table. The exact code
will depend upon the server language being used
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
Team Macromedia Volunteer for Ultradev/Dreamweaver MX
"Tim Mannah" <timmdiabetesnsw.com.au> wrote in message
news:d5rljp$i72$1forums.macromedia.com...code> After seeing different tutorials I have reached the conclution to handsomething> the insert page on my site since it has to update mutliple tablesrelevant> that is hard to do with a server behaviour.
> I have a main table with data in it called tbMembers containing heaps of
> personal data.
> I have a second table called tbMembertra containing other memberor> data.
> tbMembers has a primary key called SysMemId
> tbMembertra has a primary Key called MemExtraID and foreign key called
> The data i want to insert is stored in session variables and NOT a form.
> Some data belongs in one table the rest in the other.
> Do i really have to have separate SQL insert statements to cater for thisthe> can it be done using one SQL insert statement. I obviously want to store> relevant data without losing the relationship.
> Can someone put me on the right track for doing INSERTS as mentioned above
> into different tables?