Here is what I have so far. I am just trying to get the trigger to check the 2 frid that are on different tables before inserting the LgID into the [dbo].[ProposalProfitSplitWorksheet table:

Am I on the right track

CREATE TRIGGER [UProposalProfitSplitWorksheet]

ON [dbo].[ProposalProfitSplitWorksheet]

FOR INSERT, UPDATE

AS

Declare @lfrid int

Declare @PFRID int

Select @lfrid = (Select L.FRID From Inserted As I Join logins As L On I.lgID = L.LgID)

Select @PFRID = (Select P.FRID From Inserted As I Join proposals As L On I.LgID = P.LgID)

Thanks