amar
Posts: 8
|
Posted: 06/21/2010, 6:06 AM |
|
I am creating a search builder for multiple tables for the below situation. I have two table and its columns are specified below-
=======================
table <BOOKS>
book_id
book_name
type
=======================
=======================
table <CATEGORY>
cate_id
book_id
cate_name
=======================
Each book in BOOKS table can belong to multiple categories in CATEGORY table. That means for each records in book table there will be multiple records in CATEGORY table.
Does any one has any idea to have an Advanced Search Control which can do search in Book name as well as in Category name based on s_keyword.?
thanks.
_________________
~~ |
|
|
amar
Posts: 8
|
Posted: 06/22/2010, 9:00 AM |
|
Is there any one who has expertise in this?
_________________
~~ |
|
|
ReneS
Posts: 225
|
Posted: 06/25/2010, 6:21 AM |
|
Hi,
Create a "view" of those tables and use that for search and output.
Rene
|
|
|
amar
Posts: 8
|
Posted: 07/04/2010, 12:38 AM |
|
thanks for your response.. :) i'll try this out...
_________________
~~ |
|
|
|