if [Region]= "NE" then '94768796'
ELSEIF [Region]= "NE" then '93927594'
ELSEIF [Region]= "WEST" then '93927595'
END
18 answers
so are you just trying to blend your primary data source with 2 different secondary sources? 1 that has NE = 94768796 and 1 that has NE = 93927594?
if so just create 2 different calculated fields:
[Data source 1 blend] =
Case [Region]
when "NE" then "94768796"
when "WEST" then "93927595"
end
[Data source 2 blend] =
Case [Region]
when "NE" then "93927594"
when "WEST" then "93927595"
end
and then set the relationships to the data sources respectively.
if this is not what you are trying to accomplish can you give us a broader picture of what you are trying to do? maybe there is a different way to approach it.
