Update a field of a SQL table using a trigger from another table-field (PK)

Occasional Visitor
Good afternoon community,
I have the following tables:

dbo.RegistroGeneral: IdInpeccion (PK) int, IdEquipo int, IdEmpleado int, FechaFin datetime, FechaInicio datetime
dbo.RegistroPasos: IdInspeccion (PK) int, IdPasos nvarchar(5), ObserPasos text

What I need is that every time I enter a record in the table dbo.RegistroGeneral a trigger take the value of the
incremental key field "IdInspeccion" and pass it or update it in the field "IdInspeccion" of the table dbo.RegistroPasos.

The tables are related by the IdInspection and both tables are filled from the execution of a Button.Run of PowerApp.
In summary for the example in the image I need thefield IdInspection to be equal to 1 in the 11 registers
of the table dbo.RegistroPasos

I have never worked with triggers and as I have read it may be a solution to what I have been looking for.
1 Reply



You could create a trigger on first table as follows, and it could work


CREATE TRIGGER TriggerName_Insert ON Table1
DECLARE @newid as int ;

-- gets the column information from the first table
SET @newid = (select i.ColumnName1 from inserted i) 
INSERT INTO Table2(ColumnName1) values (@newid)



For more about triggers, you can have a look on below link. He explains all the trigger types 




Have a great day :)