Home » Community » Newbie corner » Searchable dynamic DropList
Searchable dynamic DropList [message #51397] |
Thu, 21 March 2019 15:20 |
Giorgio
Messages: 218 Registered: August 2015
|
Experienced Member |
|
|
Hi there,
I have a window that is a data entry form for a table in a db. Some of the data to be entered are referenced in other tables e.g. there is a supplier code that is referenced in the suppliers table that contains full name of the supplier, address, terms of payment etc. I would like to have a DropList widget with the capability to show the user a filtered list of results according with the text entered e.g. when the user is entering "AN" the DropList should show ANDREA, ANNA, ANTHONY etc. I suppose it is a common request and I've searched in the forum but found nothing.
Furthermore, the DropList will be dynamically populated with data from the db. To populate it, my idea is to use the Add() method on a SqlSet that is the result of a query. This will work, but I am wondering if there is a more efficient way to achieve my goal.
Thanks,
gio
|
|
|
Goto Forum:
Current Time: Fri Apr 19 02:18:51 CEST 2024
Total time taken to generate the page: 0.04232 seconds
|