You use JOIN statements to join all of the tables into a single recordset. Then you can either use parameters in your recordset or DataAssist Search in order to filter the results.
Get the unfiltered results showing from a single recordset first, then add the filter.