Adding data fields to join forms
From a database perspective, a join form is a temporary composite table. Therefore, you cannot add data fields directly to a join form. Instead, you can add only data fields that already exist in the underlying primary or secondary form. The following procedure explains how to do that.
You can add trim fields (lines, text, and boxes), buttons, panel fields, table fields, and display-only data fields directly to a join form in the same way that you add them to other types of forms.
To add a data field to a join form
- Open the appropriate join form.
- Right-click the form, and select Add Fields from formName, where formName is the primary or secondary form that contains the appropriate field.
The Add Fields dialog box appears. It contains a list of fields in the underlying form that are not on the join form.
- In the Select Field from formName list, select the appropriate fields, and click OK.
The selected fields appear in the upper-left corner of the join form.
- Drag the fields to the appropriate position in the join form.
- To modify the display properties of the new data fields:
- Select the field.
- In the Properties tab, if the properties are not grouped by category, click the Show Categories button.
- Modify the field properties in these categories as needed:
- Change History
- Help Text
See Field properties.
- Right-click the form, and select Save.