[ic] table-editor: showing more than one field as label in select widget?

[Mike Heins]

Quoting Jure Kodzoman (kodzoman at gmail.com):
> Hy list,
> 
> I have a question regarding table editor. What I would like to do is
> to have a dropdown list, where labels would be made from more than one
> field.
> 
> For example, I have a "person" table: code, name, last-name
> 
> In mv_metadata, if I have a field "owner" in table "houses", i have
> the following:
> 
> code:    houses::owner
> type:      select
> field:      code,name
> db:         person
> lookup: code
> 
> What I would like to do is show multiple fields in dropdown list, sth. like 
> 
> label: "name last-name"
> lookup by code.
> 

Either the lookup or the standard metadata method works for this;
we use it all over the admin.

    [display 
	type=select
	lookup-query="select code, fname, lname from owner order by lname"
	label-joiner=" "
    ]

-- 
Mike Heins
Perusion -- Expert Interchange Consulting    http://www.perusion.com/
phone +1.765.647.1295  tollfree 800-949-1889 <mike at perusion.com>

Function in chaos, finish in style. -- Unknown