7 Replies Latest reply on Jun 17, 2013 7:01 PM by Dimitri.B

    How do you build a relationship between 2 sources where the connection is a range

    Mike Wood

      Newbie here,


      I have 2 data sources I need to join together to help build a hierarchy. My problem is one source has a key number fields and the other source has a range. So instead of saying Source1.FieldA = Source2.FieldB I want something like Source1.FieldA IN Source2.FieldB, instead of IN it could be Between, >, <, etc. Can the relationship field mapping only work if the values are equal? Or is there a way to map fields along some sort of range.