This topic is locked

How to join fields in dropdown lookup?

4/19/2009 6:14:28 AM
PHPRunner General questions
T
tcgass author

I have a database containing a table "orders" and "customers". When adding a new record to "orders", I have defined a lookup field pointing to the field "name" in table "customers". Since I have several customers with the name "Miller" i.e. I'ld like the dropdown field to show "name, first name" - but how can I achieve this? Sorry if this is basics for most of you, but I'm rather new with Phprunner and couldn't find a solution so far...

Thanks for your input and support

Thomas

T
tcgass author 4/19/2009

Ok, I found out myself :-)
In Lookup Wizzard chose "Display field" -> "Custom Expression" and insert concat(Name,' ',Firstname)
...hm, sometimes you can't see the forest because of all those trees ;-)
Thomas