Searching Related Records from List View Advanced Search

Hi,

A client is needing to search a long List View of a table which contains a Related Records field. A few tries with the Advanced Search editor have either caused MySQL errors or return 100% of all records in the table.

I'd like to do something like this in the Advanced Search area:
Purchases:|relatedRecords001:productName|query

Where 'relatedRecords001' is the joined table and productName is the field to search on.

Any idea on how I might do this successfully?

Thanks,
J.