>Thanks for the advice. What would you recommend or how would you recommend handling it?

Create a stored procedure with an output parameter that you would populate with the @@IDENTITY. It would look somewhat like this:

Create Procedure myProc 
  (pField1 [varchar](50),.. etc., nIdent [int] OUTPUT)
As
Insert Into myDb.dbo.myTbl Values (pField1,.. etc.)
Set nIdent=@@IDENTITY

Although I don't know how you would call this from an RV (or if you can use it). I've only used SPT and ADO for this type of calls.