Passing a variabl to SQL code

[Joanne]

Hello, I have a question about a drop down box. The user picks a name from
the drop down and then, based on that value, the query button is supposed to
pull up other fields. I want to use the value in the drop down box as a
WHERE statement in the SQL code but I don't know how to capture that
variable. Thank you very much for your help.

 

[Zhang Haiguang]

You could add a rule to the drop down box, then add a "Set a field's value"
action
into the rule. Set the value of the drop down box to one of the fields
submitted by the query button in the action.
http://www.infojetsoft.com