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.