Hie i have created an application with multiple tables. Now i am having a form based on suppliers table that has two options inbound and outbound now when user selects outbound options two fields shows one is enter quantity and second the locations at which the selected product is stored.
Now i want that shipping quantity field should not accept the qty more than what is stored in its location[ which is shown as options as explained above]
Hi @RMA_J21
Welcome to the community !
Try that in the Valid_If option of the Quantity Column:
[_THIS]<[_THISROW].[Location].[CurrentStock]
For reference:
User | Count |
---|---|
36 | |
34 | |
27 | |
23 | |
18 |