This topic is locked

Drop down menu where statement

5/16/2017 8:33:42 AM
PHPRunner General questions
G
georgweber author

I would like to make a drop down list which is depends a where statment and a field which i have just field in the form.

Let´s say:

I have a form with field name, city and country. On the drop down list i would like to show all names which are in the country which i selected in the form before. That means someting like on the fly.

i have tried to use in the lookuo wizard where statment "country = '" & values("country") & "'" but this not wokrs.

Somebody have any idear?

admin 5/17/2017

You need to use Dependent Dropdowns feature. For now this is the only option. In version 9.8 though you will be able to implement a dynamic WHERE statement similar to one you describing.