I'm a little confused because I'm not looking for the scope identity or any other identity. Variables in my VB code are taking on the value of the identity column...

The inserts to the person table and all of the inserts to the person related tables that occur after the trigger insert to the audit table happen in embedded SQL...

I have a person table with personal characteristics, and separate tables (because they can have many) for names , addresses, dates of birth, driver's licenses, and ssns. Thank you so...