How I can Insert a identity field in other table?

[omauri]

Good afternoon.

I want copy the identity identifier field from a table (TblEmple) to another one (TblTercero). I used this trigger:

Declare @IntCodigo as int

Select @IntCodigo = IdsEmpId
from inserted

insert into tbltercero (IntTerEmple)
values (@intCodigo)

This trigger functions, but I use a file (*.adp) in MS-Access 2000 with conection to Sql Server database. When I write a record in TblEmple table, Access doesn't show this record and show an uncomfortable MsgBox, but the record is copied to TblTercero table. I would like to MS-Access doesn't show this MsgBox. I know that is a identity field's problem.

Help me Please,
Thanks.

 

[TomSark]

I'm having a little trouble with the wording here, so let me ask this:
Is tblTercero a SQL Server database table that has an identity on it? Tom Davis
tdavis@sark.com

http://www.sarkdallas.com