[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