[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [ic] Item Editor and Foreign Key Reference


Quoting Christian Brink (suppressed):
> 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 <suppressed>

Experience is what allows you to recognize a mistake the second
time you make it. -- unknown
_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users


Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.