Having Created a Connection, selected your database connection and defined a SELECT action.
Using the Connect behaviour on the appropriate event (possibly the When Forms is Opened event), select the database connection and action, and then in the Return Parameters section, check the Items option corresponding to the field you want to populate you list or drop-down object with; after you have checked the Items option, click on the Target column and select your drop-down or list object. Preview the form and press the button: this should now populate you list or drop-down with data from the database column.
PerfectForms Forums » Integrating PerfectForms
Populate List/Drop Down objects
(3 posts)-
Posted 3 years ago #
-
if you want to control the order that the list/drop down populates, set up a VIEW in your database to 'GROUP BY' and then create a connection action based on this view
Posted 2 years ago # -
I don't know how other DB's work but you cannot use an order by clause in a view with SQL Server unless you include the TOP function to limit your result set. It would be nice to have a sort feature.
Posted 2 years ago #
