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

Copper Contributor
 
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.

Captura.PNG
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

@EMARIN91 

 

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

 

CREATE TRIGGER TriggerName_Insert ON Table1
FOR INSERT
AS
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 

https://www.codeproject.com/Articles/25600/Triggers-SQL-Server

 

 

Have a great day :)