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.
Thanks.
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.
Thanks.