AnsweredAssumed Answered

Creating value list from SQL SELECT results

Question asked by dab222 on Nov 20, 2018
Latest reply on Nov 26, 2018 by beverly

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?

Outcomes