[ic] Item Editor and Foreign Key Reference

[Mike Heins]

Quoting Christian Brink (cbrink at brinkrods.com):
> 
> There appears (Database Lookup in the Meta Information Edit screen) to 
> be a way to add a field to the Item Editor that reference a another 
> table based on a foreign key. But I can't seem to find docs on it or 
> experiment to get it to work.
> 
> I have added a Manufacturers Table and a field called 'manu_id' to the 
> product table that references the Manufacturers Table 'id' field. These 
> modifications have been added to the Interchange table definitions.
> 
> Basically:
> Table: Manufacturers
>   id
>   name
> 

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.

-- 
Mike Heins
Perusion -- Expert Interchange Consulting    http://www.perusion.com/
phone +1.765.647.1295  tollfree 800-949-1889 <mike at perusion.com>

I am convinced that life is 10% what happens to me and 90%
how I react to it. And so it is for you... we are in charge
of our attitudes. -- Charles Swindoll