[ic] Item Editor and Foreign Key Reference
Mike Heins
mike at perusion.com
Wed Oct 19 18:45:48 EDT 2005
Quoting Christian Brink (cbrink at brinkrods.com):
> Mike Heins wrote:
>
> >This is done all over the UI via the meta editor in the tab oddly
> >enough labeled "Database Lookup". You can either put
> >
> > select id,name from manufacturers
> >
> >in the lookup_query, or you can put
> >
> > id,name
> >
> >in the field parameter and manufacturers in the table parameter.
>
> Thanks the query worked.
>
> I had been using the 'Lookup Table' and 'Field for Lookup' which did not
> populate the select box.
>
They should -- it is in effect the same thing. You do have to have
a value of some type in the first enabling field...
--
Mike Heins
Perusion -- Expert Interchange Consulting http://www.perusion.com/
phone +1.765.647.1295 tollfree 800-949-1889 <mike at perusion.com>
Experience is what allows you to recognize a mistake the second
time you make it. -- unknown
More information about the interchange-users
mailing list