[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
===============================================================