This article describes the steps needed to create a defined multiple choice field from another Table.
Multiple choice fields in forms simplifies the data entry process by allowing a user to choose a predetermined selection rather than typing in the entry. Create a multiple choice list from a dataset in an existing table.
Follow these steps to create a multiple choice field from another table.
- Expand the Combo Box and select the Dropdown option.
- Drag the Combo Box into the second column.
- Fill-in the Form Label:
- Fill-in the Field name:
- Select the Type:*
- Select the Dataset: Lookup Table
- Select the Table or View: Table:
- Select the Display Field:
- Select the Value Field:**
- Click Save
- *The field name will be created in the desired table and must be a type of number.
- **The Value Field is always the RID Column of the Lookup Table.
- When satisfied with the layout, click Save and exit Form Designer.