This topic is locked

Custom expression from two tables

9/18/2008 5:02:32 AM
PHPRunner General questions
I
Isterklister author

Hello,

I get it to work with multiple fields in the dropdown list.

How can I get values from another table too?
Ex

Table Personal

. id

. name

. age

. country (int) -> Countrylist
Table Countrylist

. id

. country
I 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

J
Jane 9/18/2008

Hi,
unfortunately it's impossible to use fields from different tables in the lookup query.

S
steveh 9/18/2008

Create a view in the database.

I
Isterklister author 9/19/2008

OK, I have to learn that to.
/Pelle