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 “Ordernum” in the “OrderForm”
- Rename the “CustomerSelect” in the panel “Attributes” by changing the “Object Name” to “CustNum”
- Now configure the following attributes:
- UI Field-> “custnum”
- Saved Field→ “custnum”
- Binding Field-> “custnum”
- List Design Fields→ |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.
Field name, in which the chosen value will be saved
Cell Display (value will be displayed in the column - fieldname of Grid-/Form-Entity
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.
