After entering the data qualification and sort order specifications (if any), choose the Go operation on the Retrieve frame to display the data you have specified.

The operations available on the Retrieve frame while viewing data vary depending on the type of query target and whether the query target has a table field or simple fields.

If the query target is a table in simple‑fields format, you view retrieve results one row at a time:

The following figure shows query results for a table displayed on a form in simple‑fields format.

If the query target is in table‑field format, you can view multiple rows in the table field. The operations on the menu are Query, Help, and End.

After QBF displays all rows retrieved by your query, regardless of format, it displays the following message:

QBF displays the sorted results of a query on a Master/Master JoinDef with records from each table in simple fields or in table fields.

If the rows are displayed in simple‑fields format, click Next to display the next single record.

The following are operations for a Master/Master join with simple fields:

If the rows are displayed in a table field, scroll through the data, if necessary, to see all rows. QBF displays an Out of Data message if you attempt to scroll past the end of the table field. You can suppress this message by changing the setting of the II_SCROLL_MSG environment variable/logical. For details, see the System Administrator Guide.

The following are operations for a Master/Master join with table fields:

When you retrieve a master record in a Master/Detail JoinDef, QBF automatically retrieves all detail records associated with it. The master record is displayed in simple fields. The detail records display in either a table field or simple fields, depending on which format you chose when you created the JoinDef.

Regardless of the format, use the NextMaster operation to go from one master record to the next. Within each master you can view all associated detail records. If the display includes a table field for the detail records, QBF loads all detail records for a single master into the table field. If all the rows do not fit in your window, you can scroll through them. QBF displays an Out of Data message if you attempt to scroll past the end of the table field. You can suppress this message by changing the setting of the II_SCROLL_MSG environment variable/logical. For details, see the System Administrator Guide.

The following figure is an example of a retrieval for a Master/Detail JoinDef.

The preceding example includes a master row and its associated detail rows. The detail rows in the table field are sorted in ascending order, based on the Task column.

The following are the operations when records appear only in simple‑field format:

Use the NextMaster operation to display a master record and the first detail record associated with it. Use NxtDetail to display the next detail record associated with the same master; the master data cannot change. If you choose NxtDetail when the last detail for that master has been displayed, QBF displays the following message:

It then retrieves the next master and its first detail record.

When QBF has displayed all rows delivered by your query, it displays the following message:

If QBF does not find any rows meeting the specifications in your query, it displays the message:

It then returns you to the Retrieve frame to enter a new query.