Yes, you can create a search that uses related data however, it may require some hand editing of the search code.
You would need to create a joined query on the results page to bring in the data from both tables.
see the following site for details on creating the joined query:
sql_join.asp