Relationship based on partially matching text
I am wondering if it possible to establish a relationship between fields where the exact text of field A matches a portion of the text in field B. What I'm ultimately trying to get to is the ability to quickly filter my contact list based on industry specialty. My field, Contacts::Coverage is a checkbox set of 10 or so predetermined industries. In another layout dedicated to Firms (with a Contacts portal), I would like to let users select an industry from a global field that filters to the relevant matching contacts. However, if a user selects "Technology" in the global filter field, I want to make sure that a contact whose coverage is "Materials, Technology" or "Technology, Financials" shows up.
Any ideas are greatly appreciated.