Blue
White
Purple
Green
Red
Orange
Blue Light
White Light
Purple Light
Green Light
Red Light
Orange Light
Hello,I get it to work with multiple fields in the dropdown list.How can I get values from another table too?ExTable Personal. id. name. age. country (int) -> CountrylistTable Countrylist. id. countryI will have a dropdown list showing "name country". If I only print:concat(name,' ',country)it will show, ex "Pelle 46" (If the name is Pelle and country 46 in the country (pointing on Country list id 46).I will have "Pelle Sweden" instead. How can I do that?/Pelle
Hi,unfortunately it's impossible to use fields from different tables in the lookup query.
Create a view in the database.
OK, I have to learn that to./Pelle