mbkrone
Posts: 1
|
Posted: 01/22/2008, 1:37 PM |
|
Hi everyone,
I was wondering if anyone has a way of searching on joined tables with CC2.0.
If anyone of you can help me with this I'd be much obliged. This is just a testproject but it would help me out a great deal.
I've set up a database called recipes and it has the following tables:
recipes
recipe_id [PK]
recipe_titel
recipe_desc
category_id
categories
category_id [PK]
category_desc
recipes_categories
recipe_category_id [PK]
recipe_id
category_id
I want my recipe table to have a one to many relationship with categories however I want to be able to perform text searches on the recipes_categories table not on the recipes table.
Anyone out there able to help me?
thanks in advance.
|
|
|
|