Inserting onto 2 tables but requiring data from 1

[BJ Duncan]

G'day to all,

I am trying to make a query that grabs data from a form, part of the form has personal details and the other part of the form has business details.

I have 2 tables in a database :
Table 1 = clientDetails
Table 2 = companyDetails

Within the table of clientDetails there is a field called companyDetailsId, this field is a foreign key field to link companyDetails table with a field within that called companyId.

My question is, can I have just one query that can insert the data of the companyTable first, then grab that companyId and have it inserted into clientDetails along with all the other personal data.

Help please - I'm very confused.

[r937]

no

inserts can be done only one table at a time

[gderas]

An option to do that it´s make the inserts in order but managed in the code of the application.