> 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?