3 Replies Latest reply: May 24, 2012 7:19 AM by Sudeep Dhoju RSS

    similar field name but different line item query

    Sudeep Dhoju

      I have 2 different tables ,one having region name1 and another as regionname2 as field name which has similar states name.When i select state name from regionname1 then the expression from table 2 reflects wrong output since it takes line item from 1st table and vice versa. So is there any method so that if we select state name from regionname1 then the expression calculated for table 2 takes statename from regionname2 so that the expression gives correct output.

       

      eg:   regionname1   regionname2

              Ohio               Ohio

              illinois              illinois

       

       

      but here if we select illinois from regionname1 then expression from table 2 gives output as '48' which is false but if we select illinois from regionname2 then it gives output as '63' which is true.

       

      what i want is if we select illinois from regionname1 it should give me output as '63'

       

      Thanks