[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
> you using?

I'm using Access with VB script. 

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

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


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

More information about the thelist mailing list