You could also probably use macros to update a database when values are selected. Perhaps something like this:
Unique ID, Field, Selected Value, Timestamp
The log would probably contain similar information, so whatever is easiest for you to create.
Then you need to load the data in. Let's say you decide you want your Customers sorted by how often they've been selected in the past three months. Something like this:
LEFT JOIN ([Customer Table])
LOAD
"Selected Value" as "Customer"
,count("Unique ID") as "Customer Selection Frequency"
FROM your data source
WHERE Field = 'Customer'
AND Timestamp >= three months ago
GROUP BY "Selected Value"
;
Then in your Customer list box, go to properties, sort, checkmark expression, and enter "Customer Selection Frequency" as the expression. Seems like it would work. I certainly haven't tested it.
