HOW TO DO IT ? & WHAT EXPRESSIONS TO USE?

[MSBPRB]

So for my manufacturing appsheet app -

i have 3 tables

table no 1 - Order Booked table no 2 - Gate Pass table no 3 - Sale table no 1 - Order Booked has these columns :- OrderBookedID Booking No. Date PartyBroker Item Code 1 Item Name 1 Item Qty 1 Despatched Qty 1 Pending Qty 1 Price Booked 1 Packing Booked 1 Packing Type 1

table no 2 - Gate Pass has these columns :- GatePassID Gate Pass No. GP Date GP Time Order Type Order Booked No. Party Name Broker Name Item Code 1 Item Name 1 Weight Per Bag 1 Qty 1 Total Weight 1 Rate Per Bag 1 Packing 1

table no 3 - Sale has these columns :- Receipt No. Date Time GP No. OB No. Order Type Party Name Broker Name Item Code 1 Item Name 1 Weight Per Bag 1 Qty 1 Total Weight 1 Rate Per Bag 1 Packing 1


want to update the Pending Qty 1 column in the Order Booked table, based on the Qty 1 column in the Sale table.


HOW TO DO IT ?  & WHAT EXPRESSIONS TO USE?

[Izzat_Safrah]

Add virtual column In Table ORDER BOOKED  and rename it to [Pending_Qty_1]  or any name you want, type Number.

Use this EXPRESSION

SUM(

SELECT ( SALE[QTY 1], [ITEM CODE 1]=[_THISROW].[ITEM CODE 1])

)