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 Form Designer of the “OrderForm”
- 👋 Search in the panel “Browse catalog of objects” for the object “CustomerSelect”
- 👋 Drag and drop the “CustomerSelect” on the “CustNum” in the “OrderForm”
- 👋 Rename the “CustomerSelect” in the panel “Attributes” by changing the “name” to “CustNum”
- 👋 Delete the old “CustNum” entry by clicking the small trash bin icon next to it
- 👋 Select “Save”
- 👋 Now configure the following attributes:
- UI Key Field-> “name”
- 💡 Here you define the field, which should be displayed in the DynSelect after choosing an option.
- Binding Field-> “custnum”
- 💡 Cell Display (value will be displayed in the column - fieldname of Grid-/Form-Entity
- Key Value→ “custnum”
- 💡 Field name, in which the chosen value will be saved
- Template Options→ |custnum|name
- 💡 The options that will be shown in the selection
- 👋 Launch the screen to see the result
💡 We want to show the customer’s name additional to the customer number
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.