To search multiple table you will need to manually create the results page, the wizard will not able to do this for you.
You would need to create the recordset using a join query to get the related information from the different table.
For details on Join Queries, see the W3Schools page:
sql_join.asp
The apply the DataAssist Search server behavior to the page to perform the filtering of the recordset.