Using Triggers To Add Foreign Keys To Child Tables

I have a situation that I must resolve. I have a program being used by many but I had to create a new table to provide a new feature. The problem I have is this table must use the primary key from the parent table as its primary key, meaning when a user adds a new record to parent table, I need to instantly add the primary key to the child table. Now this was done in the program using sql statements, but I need to implement a trigger or such as to keep me from having to reinstall application on many computers.





basically person inserts new record, then I need to get the new primary ket and add insert it into the child tables. how can I do this with a trigger. I have tried to use an insert into statment with my trigger, but I can't seem to pass the parameters correctly.











CREATE Trigger dbo.Table_Borrower_Insert_Keys


ON Table_Borrower


AFTER INSERT


AS


begin


declare @bid as int





@bid = select MAX(BorrowerID)


FROM Table_SoldProgression





INSERT Table_SoldProgression(BorrowerID)


values (@bid)


end


GO








another attempt





CREATE Trigger dbo.Table_Borrower_Insert_Keys


ON Table_Borrower


AFTER INSERT


AS





INSERT Table_SoldProgression(BorrowerID)


values (select MAX(BorrowerID)FROM Table_Borrower)





GO