I have a requirement where the user can select the 5 mutliple dropdown values,Sort for any one of 5 and operators for each value from operator dropdown and Gate operator (AND or OR).
Ex: Employee Dept(dropdown) Sort On(radio button) Operator(dropdown) GateMedical Yes = ANDTransport No is null ORFinance No includes ANDBilling No = ORDelivery No in AND
based on the user selected values I would required a query record with selected employee depts as fields in the filters with respective operators.
Can someone please provide your valuable suggestions to write queryrecord.
Thanks in Advance.
Mike Schmitt
Peter Lewis
Discussion posts and replies are publicly visible