Searching 3 fields.

Hi Anonymous 

I would recommend that you create a table which unpivots the Installer names into a single column, along with a column containing the identifer of the original record (I'm assuming a Job ID of some sort). You can also include a "Role" column. Something like this: 

This table is then related to the original table on the Job ID column, either directly or via an intermediate table containing unique Job IDs (if necessary), The relationship with the above table would need to be bidirectional.

Then you can search/filter on the single Name column.

Regards,

Owen