I really like the ability to use SQL to gather information very quickly with using SELECT, NULL, OR commands. I can get exactly the data I want to show in a menu that is almost impossible to gather otherwise. The problem now is how to get the field created into a value list. I tried the trick of using a second field and indexing that field but it either shows only one value in the menu or fails. I can make it a non global field and it works perfectly except then always having 10 or more users causes the field to change with other users needs. I have even tried creating relationships to accomplish this but without the OR relationships of files do not work.
Are there some specifics I am missing when using the second field index to use a global field as a value list?