Use a Detail Frame
The generated detail frame displays a master and a detail section. The master section of a detail frame is used to display a single row passed to it from a calling frame's detail table field. It consists of a set of VCR buttons and a slider to navigate through each selected row, with its values updated automatically in a matrix of fields. Each field is mapped by name and type to the columns of the parent frame's table field.
The detail section of a detail frame is used to display the rows of a second query of one or more joined tables that are associated with the detail query of the calling frame. It contains a table field, each of whose columns maps by name and type to the result columns of the detail frame's query.
To see the detail frame in operation
1. In the Frame Editor, open the parent frame with which it is associated.
2. Click Debug, Go on the floating menu bar.
3. Highlight a row in the detail table, and then click Open List to display the detail frame.
Note: The VCR buttons are not present if the parent is a master-detail frame running in asynchronous mode.
The Row menu provides commands to perform standard database row operations such as inserting a new row, duplicating the current row, finding text, copying the table, and saving changes to the table. For more information about finding text or copying a table, see
Use a Table Field Frame.