Solved: Automatically fill in data based on dropdown choic... - Page 2

Chacal33 · 06-19-2021 02:31 AM

Hi all,

I have 2 tables:
ORDER – OrderID - OrderDate - OrderStatus
ORDERDETAIL – OrderDetailID - OrderID - Product - QtyOrdered - QtyDelivered

I would like the QtyDelivered to be equal to QtyOrdered if OrderStatus = “Complete”

I have tried to add a formula for QtyDelivered like:
if(OrderID.OrderStatus = “Complete”, QtyOrdered,0) in appFormula and initialvalue, but nothing happens…

Any idea?

Many thanks

Matt

Chacal33

Hi,

I eventually found a way to do what i wanted.

Create an action on the order table:
Data: execute an action on a set of rows
Ref table: OrderDetail
Ref rows: SELECT(OrderDetail[OrderDetailID],[OrderID]=[_THISROW].[OrderID])
Ref action: create an action that update the data you want to update.

Done and dusted!

Matt

View solution in original post

Automatically fill in data based on dropdown choice