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 9 years, 7 months ago.

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

    ijobling
    Participant

    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.

    #4432

    ijobling
    Participant

    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

    #4466

    Anonymous

    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.