Hi all, as the title says, does Access SQL support the Insert All Into statement? I'm doing an ASP website and am trying to enter valued from a form into two lionked tables in an Access database. The standard SQL code would be

INSERT ALL INTO tblParent(name, Address) Values ('Dave','Home')
INTO tblChild(age, phone) Values ('35','1234567');

However, I keep getting a syntax error. If Access doesn't support this, how do I insert into linked tables?

Cheers, Lol

it will have to be multiple queries.

Right, I wondered if such. Here's the situation:

Parent table has a AutoNumber PK which does not appear on the form from which data is submitted to the database. This is also present in the Child table as the link field. The PK of the Child table is an autonumber which is meaningless to the situation but has to be there to satisfy Access's need for a PK. On trying two separate insert statements would I need to:

Insert into Parent table, thus generating a new record. Extract from that table the PK value, i.e. the autonumber. Then use this as a reference to insert into the Child table using a WHERE clause so that the child record matches the parent one? Make sense?

Cheers, Lol

after the parent insert use a

select @@identity as newid from parent_table

I believe it works in Access and should return the last autonumber field value.

Thanks Chris, will see where it goes!

Cheers, Lol