I have a Ref list for colors. When in the form view and the user clicks the drop down a “stick” of that color appears. This is exactly what I want to happen. However when the color is chosen what is reported to my back end database is the Key label for that row and not the actual color written out how it is in the table it references. I need the my back end to say “Red” not “1”, or “Yellow” not “2” etc.
Previously, the fix for this has been to mark the color column as the “Label” in the column attributes tab, but for some reason this isn’t fixing it. Any help?