I'm having trouble creating a relationship using a global value in the parent to a self-join child table.
The relationship is setup as shown below. Parent::g_price_tier = Child::c_Price Tier
Parent:: g_price tier is a global field with a number result. It is based on a value list of 10 possible values in Child::c_price_tier.
Child::c_Price Tier is a Case statement calc field with a number result but I've also tried changing the result to text with the same result.
A portal into the child table on a layout based on the parent produces no results.
I've tested the value list in several ways including:
- manually entering the values in the Custom list area of the Value List setup
- values from another field
- values from another file that uses the same value list.