Specifications

Creating and saving forms
518 InfoMaker
If you are told the data is not updatable
After selecting the columns, you might see a message box telling you that
the data is not updatable. For information about these situations, see
“Defining data so that a form can update a database” on page 520.
The Select Detail Table dialog box displays.
6 Select the detail table.
This is the table that is related to the master table and whose data displays
at the bottom of the form. For a master/detail one-to-many form, the data
displays many rows at a time. For a master/detail many-to-one form, the
data displays one row at a time. In the example, it is the
Employee table.
7 Select some or all of the columns in the detail table, then click OK.
The Select Master/Detail Relationship dialog box displays. It lists
primary/foreign key relationships between the master and detail tables:
8 Specify the relationship between the master and detail tables.
To do this, you identify which column or columns in the detail table have
the same values as the column or columns in the master table.
InfoMaker needs this information so that it knows which detail rows to
display when you display a row in the master table.
• If there is a primary/foreign key relationship, select it and click OK.
• If there is no primary/foreign key relationship, click More to specify
the relationship. Select one or more columns from the master table
and the column or columns in the detail table that contain matching
values, and click OK.