I have the follow stiuation:
Suposes that exits a DataBase with 2 Tables
Table A
ID varchar(50) PK
Description varchar(200)

Table B
ID1 varchar(50) PK FK(References to column ID in Table A)
ID2 varchar(50) PK FK(References to column ID in Table A)

and I want updating the column ID of Table A for cascade action using Triggers only
Who can helpme?

Why do you want to use triggers when referential integrity will do it for you?

Yes..Foreign Key and in SQL Server 2000 (I think not in SQL 7) you can set to cascade update. Triggers are only needed when you need to implement referential integrity across SQL database servers

  I saw that you IMd me on Yahoo, but I couldn't respond. I think the error you are getting is because you have the ID from table one, linked to 2 FKs in table 2. Why would you have this structure?

For jbenson001:
I have a Table where storage the parameters that can be defined by users, and this parameters are classified in simples or complex. The Table A storage all parameters defined by users without its relations; and the Table B the storage relations into parameters for example:
- User1 define following parameters:
param1 (simple)
param2 (simple)
- User2 define following parameters:
param3 (complex), and formed by
 i) param1
 ii) param2
- User3 define following parameters:
param4 (complex), and formed by
 i) param 2
 ii)param 3

therefore i need this scheme of tables and Sql Server 2000 not allow me set up both ntegrity referencial with cascade update action, in order to obtain this behaivor i see the TRIGGERs like solution