Good day all,
I'm developing an internal Org App. I have a combo box being fed by an Excel table of approx. 1200 lines containing Key data (NB: Table limit has been set to 2000). When I click on the dropdown chevron, I can scroll through all 1200 records, but when I start trying to type the record keys, all values disappear. (See Image below. Larger Screen shots in attachments)
 | NB: ANZSCO field uses double layout, but only trying to search on key "Code" atm. Sample of Data source excel file provided for comparison. Data file is Excel Container "ANZSCO_List") |
However, next field down, Region, works as desired
 | Only difference between 2 fields is region table (LGA_Region) is only 80 rows and display list is formula using "Sort(Distinct(LGA_Region,Region),Value)" to show only distinct Regions in alphabetical order. |
Would appreciate any assistance. Have been stuck on this for last week. Why is search selection not displaying for ANZSCO field as I type, but is for Region????
Cheers
Stephen