In several instances, I have a drop-down list which is derived from SQL (which means that the contents of the list are dynamic and change as values elsewhere in the IQbase change). In the instance illustrated, the drop-down list is very long and it takes far too long to select an item from it. I am continuing to investigate ways of restricting the length of that list. But my task would be considerably easier if I could "home-in" on the field value by typing the first few characters.
In the first illustration, we see part of a grid in which a field ValidTag, highlighted as point 1, is about to have a value chosen as the user clicks on the field – see point 2.
FROM WIKITag ORDER BY left(WIKITag.WIKITag, 255) asc;
In the third illustration, we see some typical possible values:
This auto-completion already works for fields where the list of valid values is fixed, not derived from an SQL statement.
Is this possible for SQL-derived values? Would any other IQ users see this as a valuable development?