i have started a new product type, based on the book. i understand how the filtering system is used, but have a quick question about adding a text based search.

I have several fields which are in the product_XXXX_extra table, and I would like to be able to add all of these fields to the search so that I can

1. get results when typing in the general search. i don't want a drop down, I want to type any combination of keywords, and search:
a. the basic product table
b. the product description table
c. the new product_XXX_Extras table and all the fields in it ***

I also want to extend this search capacity to:

2. get results when I do a more advanced search

so i am guessing i need to create an override for the includes/modules/pages/pages/advanced_search_result/header_php.php

any suggestions?