In this case, the applications group is inserting only one tb1 record in a transaction.

1 or more tb2 records could be inserted.

I would like the identity value from the tb1 insert returned so I can use it to update on all the tb2 records.

(It would be nice if the appl would do this for me, but not in their scope) :).