Valid Value to be entered

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]

0 1 77
1 REPLY 1

Aurelien
Google Developer Expert
Google Developer Expert

Hi @RMA_J21

Welcome to the community !

Try that in the Valid_If option of the Quantity Column:
[_THIS]<[_THISROW].[Location].[CurrentStock]

For reference:

Top Labels in this Space