[thelist] SQL: insert into mutiple tables help
Cory Preus
cory_preus at cnt.com
Tue Apr 10 17:05:41 CDT 2001
> 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?
More information about the thelist
mailing list