You can build a database query with child relational table data criteria from any child relational table associated to a parent table that is associated directly to the database.
- You can create a database query in several areas. Do one of the following.
- Go to Queries and click Create.
- Go to View Data, click the Queries tab, then click Create Query.
- Go to View Data, click the name of the Database you wish to query, then click Create Query.
- Go to View Data, click the name of the Database you wish to query, then click the Queries tab and click Create Query.
- From any of the above areas, do the following.
- Click Relational Table.
- Click Choose to launch a selection box listing relational tables and/or parent relational tables available to query.
If you select a parent relational table, all child tables associated to that parent are available in this query.
- Click Done.
The parent table and all child relational tables associated to this parent are listed when you click Select Table Field. Parent table names are always listed on top in bold, followed by parent table field names which are alphabetized and indented. All child tables are listed alphabetically below the parent table.
- Build the database query and click Done to view a summary.
- Choose an action (Save, Save and Calculate, etc) for your query and click the corresponding button.
- The top row always displays relational table: Parent Table Name.
- When a child table association exists, query criteria are displayed as Table Name / Field Name.
- When no child table association exists, query criteria are displayed as Field Name.