12.1.2.1.1.18.1. Multi-Select Dropdown – Quick Forms

Applying the Quick Forms feature to a multi-select dropdown control depends on whether it references a system table or another form. Follow the steps below for each scenario:

Referencing a System Table

1. Drag a multi-select dropdown control from the toolbox and drop it onto the design environment.
2. Provide a caption for the control.
3. Specify the corresponding system entity in the Server ID field to associate the control with an existing table in the database.
   • Enter a Server ID consisting of the name of the attribute followed by the name of the system entity.
   • For example, “AuditorUser” would indicate that “Auditor” is the attribute and “User” is the reference to the User table.
     
   1. Save the form and select Yes in response to the following prompt:
      

!In the Entity Designer, users will find the mid-entity created with its two foreign keys linking it to the main entity and specified system entity, respectively. Note that the caption (name of attribute) before the system entity is used primarily to keep track of which attribute is being referred to in the database.

Referencing Data from Another Form

1. Drag a multi-select dropdown control from the toolbox and drop it onto the design environment.
2. Provide a caption for the control.
3. Specify the corresponding custom entity in the Server ID field to associate the control with a custom table in the database.
   • Enter a Server ID consisting of the name of the attribute followed by the name of the custom entity.
   • For example, “NameProduct” would indicate that “Name” is the attribute and “Product” is the reference to the custom entity.
     
4. Save the form and select Yes in response to the following prompt:
   
5. Reopen the form and access the Control Properties panel.
6. In the Control Properties panel, navigate to the Binding category.
7. From the Binding category, access the Control Properties window.
8. In the Control Properties window, navigate to the Single-Select tab.
9. Define a new dropdown data source by clicking on the button. It will display the Query Editor window.
10. To call the correct information, create an SQL query.
    • Construct your query using the appropriate syntax and logic.
      • Sample Query: select id, [Attribute] from ray.BPMAPP_[Entity] (that is, the entity from which data is being pulled).
        • Example: select id, Name from ray.BPMAPP_Product

!In the Entity Designer, users will find the custom entity now added to the database. They will also find the mid-entity created with its two foreign keys linking it to the main entity and custom entity, respectively.

*For more information on the Quick Forms feature, click here.