Hi All
I Have Tow Tables One Main for Main Information And 2 Child For Loan Values
 I Need TRIGGER Do Balance in Loan Table Whene I Insert New REcord In Main
Table
like This



CREATE TRIGGER [monthly_Action _insert] ON monthly_Action
FOR Insert
AS
Declare @NewM Money,
 @NewA Money,
 @NewB Money,
 @NewD Datetime,
 @TheNo bigint

select @TheNo = PensionNo from inserted
select @NewD =P_Date from inserted
select @NewA =Loan_Value from inserted

IF @NewA >0
Begin
SELECT @NewB = BALANCE FROM P_LOAN WHERE L_PENSIONNO= @TheNo
Update P_Loan Set Balance = @NewB-@NewA WHERE L_PENSIONNO= @TheNo
end

Thankes

Based on the snippet you've posted, I'm assuming you are working on SQL Server. Does this trigger fail to compile for you, or does it not do exactly what you want it to do. If the former, please post the error message. If the latter, please explain what functional changes you would like to see.

Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC