Hello
I use the dropdown, the data are reflected in the order of creation.
Indicated in Order fields - aid/desc
How to get the latest data from the db?
Thanks
You could look at the Dynamic Dropdown demo form.
Sorry but what do you mean it's not found? You don't know where the demo forms are, or your one doesn't have the right option?
As to getting the "latest" data from the DB, does your tab;e have an automatic ID or some other way of telling which are actually the latest values? Or could you order by created_on / modified_on?
Unfortunately doesn't have the right option among demo forms
There is an automatic id (aid) and there is created
If i point out in Order fields -aid/desc
then an error - 1054 Unknown column "form.aid" in "order clause"[file=10946]2018-09-05_144126.jpg[/file]
[file=10947]2018-09-05_144006.jpg[/file]
Well as long as your table actually has an aid field it should be working. Either way you need TWO fields retrieved if you're using "return an array of key value pairs"