AnsweredAssumed Answered

Relationship based on partially matching text

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

Title

Relationship based on partially matching text

Post

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. 

Outcomes