[ic] Search across multiple tables

Ed LaFrance interchange-users@lists.akopia.com
Tue Jun 5 12:08:01 2001


At 02:49 PM 06/05/2001 +0100, you wrote:
>is it possible to perform a search across multiple tables in a database.
>
>i.e. Search through orders based on customer details or items bought.
>Customer details are in transactions table and products purchased in
>orderline table.

mv_search_field (sf) does take a table:field syntax, so it is possible to 
qualify search results with data in multiple tables. It tends to work best 
with coordinated searches.

- Ed L.








>_______________________________________________
>Interchange-users mailing list
>Interchange-users@lists.akopia.com
>http://lists.akopia.com/mailman/listinfo/interchange-users

===============================================================
New Media E.M.S.               Software Solutions for Business
463 Main St., Suite D          eCommerce | Consulting | Hosting
Placerville, CA  95667         edl@newmediaems.com
(530) 622-9421                 http://www.newmediaems.com
(866) 519-4680 Toll-Free       (530) 622-9426 Fax
===============================================================