>it's possible to make an insert in two table in the same query

Thanx! But How can I do this? With Inner Join?
Let me explain a little bit..

I have a table Named Members_Numbers who will create an automatic number, save password, AccesLevel and the email and another one named Members_Infos who will contain others informations about the members...(Street adress, etc..)

The number created automaticaly will be the member number.. I need it to add the others info in Members_Infos. A relation is set between Members_Number and Members_Infos with the Memer_Number fields...

So.. when the user push the submit button, I have to insert informations in two tables... I found how with an Inster in Members_Numbers, select the last record of Members_Number then get the Number and another insert in Members_Infos.. Then 3 query to add :((

Thanx a lot!