1 Context:
In this task, we will add a dropdown menu to an existing form. We will use the dropdown menu to link two tables/objects together. In our case, we want to connect the order and customer tables in a different way. We will use the dropdown menu to display the customer number in the order form that corresponds to a specific order number.
2 Result:
3 Step by step guide:
- Open the Screen Designer of your order overview screen
- Open the Object designer for the master object of the “OrderForm”
- Search in the panel “Library of objects” for the object “CustomerSelect”
- Delete the field “CustNum” entry by clicking the small trash bin icon next to it
- Drag and drop the “CustomerSelect” on the “CustNum” in the “OrderForm”
- Rename the “CustomerSelect” in the panel “Attributes” by changing the “name” to “CustNum”
- Now configure the following attributes:
- UI Key Field-> “custnum”
- Binding Field-> “custnum”
- Key Value→ “custnum”
- Template Options→ |custnum|name
- Launch the screen to see the result
We want to show the customer’s name additional to the customer number
We are going to add a new select for that field
So this field in the Form is showing the data of the CustNum field of the DSO
Here you define the field, which should be displayed in the DynSelect after choosing an option.
Cell Display (value will be displayed in the column - fieldname of Grid-/Form-Entity
Field name, in which the chosen value will be saved
The options that will be shown in the selection
4 Explanation:
The dropdown/dynSelect is usually used in the B1 environment to link two tables together. Additionally, it can be used for other use cases such as searching within the same table or prefilling other form fields.