On the graph is there a valid relationship between GPIGroupCode on the left and GPIGroup on the right?
If there is do you see related values when you put a GPIGroup portal on a GPIGroupCode layout?
I think you have it backwards. Following your description, this TO …
If I look at the relationship in a portal, it appears correctly as:
TO: GPIGroupCode (GPIGroup)
Code: 00 Name: Placebo
Code: 01 Name: Penicillins
Code: 02 Name: Cephalosporins
… should be the one to draw values from, but is – according to your VL setup screenshot – the one used as context (starting from).
I have tried this every which way. My relationship is pictured below:
And the relationship does work in a portal showing GPIGroupCode on the a layout based on the TO GPIGroup pictured below
But I still get the dreaded:
I am OBVIOUSLY missing something trivial, but I cannot see it!
Care to post your file?
I am still trying to figure out how posting of files works in this new forum. I uploaded the file and gave access to you, but I am not sure how you "find" it...
I am still trying to figure out how posting of files works in this new forum
I guess just like in the olden days: Use the “Advanced Editor”, then the “Attach” feature to attach the file directly to your post (and give everyone access).
I have tried both ways (basing the value list on GPIGroupName and GPIGroup). Both Value List dialogs should show above. I am trying to create a value list of all GROUP rows that have "00" in the Class and SubClass fields. The above portal shows the first 10 rows of this correctly.
1 of 1 people found this helpful
The value list works just fine – provided you use it in the correct context (try to add a dummy field, put it on the GPIGroup layout and format it with the value list).
The context your Code field is on cannot resolve the relationship.
If you need the code in another context, create the relationship / define the value list from there – or, as a quick fix, relate Popup to GPIGroup by a Cartesian relationship; now the relationship can be resolved, and the VL filled.
See, I told you I was missing something simple!
Because most of my value lists are not dynamic, I am accustomed to being able to drop them into most ANY context without problems.
Thank you very much!