Skip to main content

Quick Guide

Last updated 12/04/2022

Quick Operations

The following is a quick guide for the basic fundamentals when in the Table and Fields Designer.

Add a Table

  1. Click the Add Table button.

Add Table Button
Figure 1 - Add Table button

  1. Click a table name.

Select Table Name
Figure 2 - Select table name

Remove the Table Selector Dialog Box

  1. Click outside the the Table Selector Dialog Box.

Position a Table

  1. Click, hold, and drag the table to the desired position.

  2. Release the table.

Remove a Table

  1. Click the Cancel button in the header of the table.

Remove Table
Figure 3 - Remove table

Add a Field

  1. Double click a field name in the table.

Select Field Name
Figure 4 - Select field name

Change a Field

  1. Click the lookup icon in the Field field.

Field Lookup
Figure 5 - Field lookup

  1. Select a new field name.

Select Field Name
Figure 6 - Select field name

Remove a Field

  1. Click the Cancel button for the table and field selection.

Remove a Field
Figure 7 - Remove a field

Unshow a Field

  1. Click the Show checkbox.

Show Checkbox
Figure 8 - Show checkbox

Add Criteria to Filter

  1. Type the clause to filter by in the Criteria field.

Criteria Field
Figure 9 - Criteria field

Add an AND Condition

  1. For field one, type a condition in the Criteria field.

  2. For field two, type a condition in the Criteria field.


AND Condition
Figure 10 - AND condition

Add an Or Condition

  1. Click the Add Or button.

Add Or Button
Figure 11 - Add Or button

  1. Type the OR condition in the Criteria field.

OR Condition
Figure 12 - OR condition

Remove a Row Holding Criteria

  1. Click the Cancel button at the beginning of the row.

Remove Criteria Record
Figure 13 - Remove Criteria field

View the Details of a Relationship

  1. Click the Cog on the relationship line.

Cog Icon
Figure 14 - Cog icon

Close the Relationship Dialog Box

  1. Click the Close button.

Run the Results

  1. Click the Run button in the Table and Fields Designer app bar.

Run Button
Figure 15 - Run button

Enlarge to Fullscreen

  1. Click the Fullscreen button in the Table and Fields Designer app bar.

Fullscreen Button
Figure 16 - Fullscreen button

Remove Fullscreen

  1. Click the Exit Fullscreen button in the Table and Fields Designer app bar.

Exit Fullscreen Button
Figure 17 - Exit Fullscreen button

Cancel All Changes

  1. Click the Cancel button in the Table and Fields Designer app bar.

Cancel Button
Figure 18 - Cancel button

Save all Changes

  1. Click the Save button in the Table and Fields Designer app bar.

Save Button
Figure 19 - Save button

Zoom In

  1. Click the Zoom In button.

Zoom In Button
Figure 20 - Zoom In button

Zoom out

  1. Click the Zoom Out button.

Zoom Out Button
Figure 21 - Zoom Out button

Diagram to Fit Screen

  1. Click the Fit View button.

Fit View Button
Figure 22 - Fit View button

View SQL

  1. Click the SQL tab in the Table and Fields Designer app bar.

SQL Tab
Figure 23 - SQL Tab

Hide Results

  1. Click the Hide Results button.

Hide Results Button
Figure 24 - Hide Results button

View Results

  1. Click the View Results button.

View Results Button
Figure 25 - View Results button