I am hoping I am missing something easy in setting up an SQL query with a drop down box. How do I set a drop down box to only accept the query output?
I have custom comment fields in DFM that are used to provide certain volumes based off of other input. However, a customer can still type text freeform into the query box, and I need to restrict that. The input box should only accept the query output for security reasons in this situation.
I believe that is controlled by the 'Lock Values:' attribute on a User Input field. If it is checked, the user will not be able overide but only choose one of the query results. When it's not checked they can type something else into the field.