AnsweredAssumed Answered

Relationship based on partially matching text

Question asked by trialuser1111 on Feb 4, 2010
Latest reply on Feb 12, 2011 by CodySteele


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.