Allow numeric select lists to index numeric data types in forms
In forms, you can not index a numeric field from a dropdown. This I am sure is for data integrity. The problem with this is that I have an external select list with a local data connector to my accounting database that has a column with an int data type. It recognizes it when I use it for an autoindex. Forms however do not recognize it. For my purposes, a quick solution would be to simply allow a numeric form field to be linked to a multi-column select list. That is what I am trying to do anyway. At DocuWorld when they were demonstrating the linking of multi-column select lists in forms I specifically asked this question "So I can set it up so that my users can choose a description and it will fill in the number?" they said yes I could do it. My problem was that I neglected to say that I wanted to index the number as a numeric data type.