Users Guide
Defining Forms

To run a form you are not currently working on:

• Click the Preview button in the PowerBar, select the form in the Run/Preview dialog box, then click OK.

To run a form you are currently working on:

• Click the Run button in the PainterBar.

To specify criteria to limit the data:

1. Do one of the following:

   • Click the Criteria button in the toolbar.

   • Select Rows>Specify Criteria from the menu bar.

   InfoMaker clears all the data.

2. Specify the criteria.

   In master/detail forms, you specify the criteria in the form's master area, which is a freeform area for master/detail one-to-many forms and a grid area for master/detail many-to-one forms. Both are like the grid you use when defining data using the Quick Select data source.

   Use expressions and operators in the blank spaces of the grid to specify criteria.

   To specify a second set of criteria in a master/detail one-to-many form, press Page Down to get a new entry form and specify the criteria in the new master area. The second set of criteria will be ORed with the first set; data is retrieved if one set or the other set is true.

   For information about expressions, see Using Quick Select, and Operators and Expressions.

3. Do one of the following:

   • Click the Apply button.

   • Select Rows>Apply Criteria from the menu bar.

   InfoMaker retrieves rows based on the criteria.

4. If you want to modify the criteria, repeat steps 1 through 3.

To import data:

1. Select Rows>Import from the menu bar.

   The Select Import File dialog box displays.

2. Navigate to the folder you want and select the file from which you want to import the data.

   The types of files that you can import into the form are shown in the Files of Type drop-down list.

3. Click Open.

   InfoMaker reads the data from the file. You can view the data and save it in an external file.

To save data in an external file:

1. Select File>Save Rows As from the menu bar.

   The Save As dialog box displays.

2. Choose a format for the file from the Save As Type drop-down list.

   When you choose a format, InfoMaker supplies the appropriate file extension.

   If you want the column headers saved in the file, select a file format that includes headers, for example Excel With Headers. When you select a with headers format, the names of the database columns (not the column labels), are also saved in the file.

   Saving the data as a Powersoft report or HTML table

   Choose Powersoft report in the Save As Type box to save the data as a Powersoft PSR file. Choose HTML Table in the Save As Type box to save the data as an HTM file.

   For information about PSR files and about working with files saved as HTM files, see Enhancing Reports

3. Name the file.

4. Click Save.

   InfoMaker saves all rows in the file; all columns in the rows are saved.

To print a form:

• Do one of the following:

  • Select File>Print from the menu bar.

  • Add a command button to a form, associate the print action with the button, and click the button.

  For information about adding a command button and associating an action with a button, see Enhancing Forms.

To access a form:

1. Click the Open button in the PowerBar.

   The Open dialog box displays:

   

2. If necessary, select Forms in the Object Type box.

3. Highlight the form you want in the list and click OK.

4. The form displays in Layout view in the Form painter. You can work on the design of the form there.

   For more information, see Enhancing Forms.

5. Click the Run button to run the form.

   When you run a form, InfoMaker retrieves data from the database and displays the form so that you can view and change information in the database. For more information, see Running forms.

To delete a form:

• Use the Library painter

  For more information, see Copying, moving, and deleting objects.