[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
Re: [ic] Search across multiple tables
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
===============================================================
