When modifying a form, you might realize that you have not included all the columns you need, or you might need to define retrieval arguments. You can modify the data source from the Form painter by graphically modifying the SQL SELECT statement.
To modify the form’s data source:
Select Design>Edit Data Source from the menu bar, or select Edit Data Source from the form’s pop-up menu.
If your form style is Master/Detail
For a master/detail many-to-one or one-to-many form,
the Select Data Source dialog box displays. Select the data source
you want to modify: the master or the detail.
InfoMaker returns you to the Select painter.
If you used Quick Select to define the data source, this might be the first time you have seen the Select painter.
For information, see “Using SQL Select”.
Modify the SELECT statement graphically using the same techniques you used when creating it.
Click the Return button to return to the Form painter, or select File>Return to Form Painter from the menu bar.
Changing the table
If you change the table referenced in the SELECT statement,
InfoMaker maintains the columns in the Layout view (now from a different
table) only if they match the datatypes and order of the columns
in the original table.
You can add columns to the SELECT statement. However, the column does not automatically display in the Layout view. You need to add columns manually, one at a time.
To use a new column in a form:
Click the Column button in the Controls drop-down toolbar, or select Insert>Column from the menu bar.
Click where you want to place the column.
In the Select Column dialog box, select the new column and click OK.
