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

Mike Heins mike at perusion.com
Fri Aug 5 08:30:36 EDT 2005

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.

	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

More information about the interchange-users mailing list