[ic] table-editor: showing more than one field as label in select
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
> 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"
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