inserting into multiple tables

[twright]

i have a database with 2 tables. the first table is a player info table,
and the second table is a stats table. i have an automatic number assigned
to each new user, and am using this as the primary key in the player info
table. i'm taking this number, and using it as a foreign key in stats
table. once the user submits their info, and click the next button, it
takes them to the stats page where they then fill out that form. the
problem is putting that primary key value into the stats table. i was
thinking about using a hidden form field, but how would i pull that info
from the previous table? can anyone solve this problem? i would appreciate
any help that i can get. thanks.

 

[haslo]

Try having a look at thread333-92296 - but it could very well be somebody has a better solution...

allow thyself to be the spark that lights the fire
haslo@haslo.ch - www.haslo.ch​