4 Replies Latest reply on Jun 17, 2011 11:46 AM by philmodjunk

    Multi-Criteria Match Fields



      Multi-Criteria Match Fields



      I'm attempting to use a calculation field that returns a Carriage-Return delimited list that I would like to uses as the match field on both sides of a self-join.  As has been so often the case lately, expectations and outcomes appear mutually exclusive.

      Here's what I have:  Two occurances of "Organizations" - "Organizations_All" and "Organizations_Select" and one occurance of "Cities".  The relationships: Organizations_All::fk_CityId = Cities::pk_CityID and "Organizations_All::k_Constraints = Organizations_Select::k_Constraints.  The Layout's Table is "Organizations_All" and "Organizations_Select" is displayed (or is supposed to be) in a portal on that layout.  There is also a global field that accepts input in the form "City, State" from the "Cities" table and finds the corrosponing record in "Cities".  I'm trying to use values in the field "Organizations::OrganizationType" to generate my calculated match field "k_Constraints".  The available values would be "Agents", "Subscribers" and "Contractors" and any number of those can be present on either side of the relationship.  Then I thought, why not have each organization whose "City, State" value matches that of the global field throw that into k_Constraints as well.  So each side of the "k_Constraints" relationship could conceivably have up to 4 values.  At any rate, the portal draws a blank, and I'm drawing a blank trying to fix it.  Am I missing something obvious?