[ic] Modifying an existing search to include fields from another
rphipps at reliant-solutions.com
Thu Mar 10 23:20:46 EST 2005
I have the following search profile which currently works.
I would like to modify this profile so that it will not only look in the
products table, but it will also check the name column in the mfgr table
as well for the search term. In the products and the mfgr table there
is an mfgr_id column which joins the two tables.
I've read this text on coordinated/joined searches:
l, but I don't see how to specify the primary/foreign key fields to
complete the join. In the examples they use the inventory table which
has a sku column as does the products table. Is it possible to join on
other fields besides the primary key 'sku' of the products table?
More information about the interchange-users