Relationship Help (conditional relationship)

Discussion created by deninger on Oct 24, 2014
Latest reply on Oct 27, 2014 by deninger

I am working with a relationship that I am having difficulty modeling within FM and I was hoping someone might be able to push me in the right direction.


The relationship is set to include both matching attributes A and B as illustrated below.


Table 1 Table 2

Attrib_A _________/ Attrib_A // Attrib_A and _B are both > 0

Attrib_B /  Attrib_B


This works fine, but I also want the relationship to resolve to just:


Table 1 Table 2

Attrib_A >---------< Attrib_A // only match on Attrib_A because

Attrib_B Attrib_B // Attrib_B in Table 2 is set to "00" or is empty


in the case that Attrib_B in Table 2 is either empty or "00" (the default "all" value)


Is this possible in FM? I am trying to think of a calculation trick to enable this, but so far I have come up blank.