[thelist] SQL: insert into mutiple tables help

[Cory Preus]

> This is the better solution.  However, you may not have to actually use a
> separate SQL query to get the FK. What language are you using? What DBMS
are
> you using?

I'm using Access with VB script. 

> If your db has triggers, a trigger that fires on inserts would be the
slick
> way to go. Rudy, what say you?

Triggers would be the way, but Access...you know.

> @@IDENTITY

I think that might do it...unless Access doesn't support that SQL function.
Anyone know?