re: implementing search wizard
if you already have a search form and a results page, you should not use the wizard, you should use the server hevior.
on the results page, go to the bindings panel. click the plus button, and select form data. select the search form page.
This adds bindings for the search form.
then add the data assist search server behavior. click the plus button to add a new criteria. From the columns list, you can use ctrl+click to selct multiple columns.
for the value, click the lightning bolt and select the form element to use.
I'm trying to get the search form on my homepage work with my Products table. The searchbox was created automatically by the webassist template.
I'm unsure whether or not I can make this search box work with my database or if I have to delete it and insert a new search bar.
I like the idea of having only one form field for users to search for, and like 'mrs' above I'd like it to query both SKUs and Product Name