I have a Combobox that has a Excel table (Table1) as a data source. The table has 1265 rows of data and a column called Brand
I have the data in my combobox set to Distinct(Table1,Brand)
This works, but is only showing the first 15 brands (there are 31).
Any idea why this is?
Go to Solution.
The distinct function cannot be delegated so it only looks at the first 500 of 1,265 rows and finds the unique results.
You can increase the delegation limit in Advanced settings to 2,000 rows. In your case this should produce the correct result.
---Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
View solution in original post
Keep your eyes open for our upcoming T-shirt design contest!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020