Data source - ComboBox |
![]() ![]() ![]() |
When a table type data source is selected, then the user must associate the relationship that will be used in the items of the List of values. See how to perform this association:
1.In the form designer, select the desired item (List of values). At this point, the Properties panel will be updated. Select the Table option and click on the Data source button. The following screen will be displayed:
2.In the General data section, fill out the following fields: Table/Relationship: Select, in this field, the relationship that will be used in the combobox. If the desired relationship does not exist, click on the Field: After selecting the relationship in the previous field, this field will be enabled. Select, then, the field (target table) that will be related to the form in question. Click on the Form to add a new record: Select the form that will be used to add the records that will be used in the relationship.
3.In the Filter selection section, the filter of a relationship must be configured when there are two or more relationships in the table. To do that, select the table that will filter the records of the relationship in question in the Filter field. N-1 Search field: Check this option if the filter to be used comes from a relationship of the table selected in the Filter field. ▪Relationship: In this field, the system will display the relationships of the table selected in the Filter field. Select the relationship that will be used as filter. ▪Table: This field is automatically filled in with the name of the target table of the relationship selected in the previous field. N-N Search field: Check this option if the filter to be used comes from a table related to the table in the Filter field. ▪Table: In this field, the system will display all the tables related to the table in the Filter field. ▪Relationship: In this field, the system will display the relationships of the table selected in the previous field. Select the relationship that will be used as filter. ▪Table: This field is automatically filled in with the name of the target table of the relationship selected in the previous field.
4.
5.Save the relationship record. |