Noled and Alamir:

Noeld,

Thanks Noeld for the info.  I have been changing the queries based on using the x-Ref in Access Analyzer from FMS to find the queries that contain the...

Noeld,

I checked the table and it does have an identity field and there ate no triggers associated with this table.

**********************************

Alamir,

Thanks for the suggestion.  I will be trying it out in...

Here is the sp:

/****** Object:  Stored Procedure dbo.INTERFACE_BATCH_CREATE    Script Date: 3/28/2002 12:57:08 PM ******/

/********  Altered 4/23/02 For RV & BK Invoices *********/

/********  Altered 4/26/02 For Warnings *********/

CREATE PROCEDURE...

Thanks for your quick response.

Tried Scope_Identity and the result was still null.

I will check into the triggers.

Thank you.

the-developer