Problems with DataSearch

I am having an issue with DataSearch. Why does the DataSearch wizard selects all of the fields of a table when I am using a query to filter 3 fields for my repeat table? Also, does DataSearch handle advance queries such as, JOIN tables? And is there a tutorial for properly using DataSearch?

I'm not sure i follow.

the DataAssist search wizard uses the recordset that you create as a base.

Before using the Data Assist search wizard, you should create the results page.

create the recordset that will be used by the results page without any filtering, and create the results layout, then run the security assist wizard. The wizard will create the search form for you and add code to the result page to filter the recordset based on what is entered in the search form.

the recordset you start with can be a join query or a standard one table query.

Below is my query
SELECT products.ProductName, productcategories.CategoryName, producttypes.productType
FROM products

LEFT OUTER JOIN productcategories ON productcategories.CategoryID=products.ProductCategoryID
LEFT OUTER JOIN producttypes ON producttypes.productTypeID=products.productTypeID

WHERE products.ProductStock>0

When I am at the Advanced text search window, the wizard brings all of the fields from products table and not from my recorset.

I have tried using different tables from my database and creating a simple query and still the wizard pulls everything from the table and not the recordset.

Is this normal or it just a bug that I am experiencing? I am using CS 4, Windows 7 Pro, DataAssist 2.1.0, and Design Extender 1.0.2

Yes, the wizard will only show columns from the main products table, you will only be able to search on columns in the products table, but you will be able to show information from the related tables.