Dear guys, really appreciate any help or advice on this
I have an app with Main Orders, this Main Order can have several Purchase Orders for different (or same provider). Before create a new PO for a provider i need to count previous quantitate of orders for the chosen provider, from a dropdown. I´m counting this way
COUNT(
SELECT (TABLEORDERS[ORDERSID], AND([MAINORDERID]=[_THISROW].[MAINORDERID],[PROVIDER]=[_THISROW].[PROVIDER]),FALSE)
)
MAINORDER and PROVIDER are chosen in different dropdowns
The problem is that the app is counting the actual choice! I need the count for previous orders and not include the order I’m creating!
Really appreciate any advice or help on this
Regards
Carlos