Populate List/Drop Down objects

Home Forum Integrating PerfectForms Populate List/Drop Down objects

This topic contains 2 replies, has 0 voices, and was last updated by  ijobling 12 years, 6 months ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
  • #33


    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.



    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



    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.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.