Inserting into two tables problem

wxdqz

New Member
Hi
Ihave two tables that I wish to insert data into.

Problem is that one of the values of the second table is an auto_inc value from the _first_

Do I have to use two inserts?

Here's the example

tab_one
id(auto_inc)|val1|val2

tab_two
id|val(id from tab_one)


See what I mean?

Nick
 
Back
Top