Hi;
(PHPRunner 5.2 (Build 4905))
We have 2 Tables and 1 Form
Area Table
Area
Country Table
Area
Country
Form
Area (input)
Country (input) with Dropdown box with the countries that belong to the Area select before
Another is $values, the same string that is used in the Events
$values - array of values to be written to the database.
To access specific field value use $values["FieldName"]
We want do a dropdown dependent, but using WHERE, (
We put in the Visual Editor - Field Country - Properties
Lookupwizard
Table --> Country
Linkfield --> Country
Display field --> Country
[color="#0000FF"]WHERE "Area =" .$values("Area") We hope that Where clause filter the countries that belong to the Area that select before
But It do not work,
Error Type 8
Undefined variable: values
Are we doing some thing wrong or $values do not exist in this moment in the page?
Are there another way for to filter the content of Dropdown box by the fields that the user wrote? [u](No using dopdown option. In this way we will can do filters more specific)
Thanks in advance
Aleix