There are two data sheets belong to the main relationship, the main fields are as follows:
BnewGoods Table:
Inmat_no (PrimaryKey)
GROSS_WT DECIMAL
NET_WT DECIMAL
BnewGoodsDetail Table:
Inmat_no (feed single number)
Car_order (send a car form, primarykey)
Gross_wt
NET_WT
The problem now is: Gross_Wt in the table above, NET_WT is a summary of Gross_Wt, Net_WT in the schedule.
How to write a trigger, when the gross_wt in the list, the number of the number in the primary table is changed. Claim
The primary table can also increase, as if the number of summary of the summary table is not added to the number of times the short table.
