INSERT INTO tbl1 INNER JOIN tbl2... Is this possible?

[Crowley16]

I am just wondering if you can do a insert into a join, instead of a direct table.

Basically I have 2 tables with a 1-Many relationship. Main table has a Autonumber field as PK, and what I'd like to do is to insert directly into both of these tables and have the 2nd table pick up the autonumber automatically...

Thanks

--------------------
Procrastinate Now!