6. Using JoinDefs in QBF : JoinDef Definition Frame : Choosing Table-Field Format
 
Share this page                  
Choosing Table-Field Format
The Table Field Format? or Simple‑Fields Format? question controls how this JoinDef displays data:
Master/Master—If the JoinDef contains all master tables, answer this question with y (yes) to specify table format for all data. Answer this question with n (no) to display all data one record at a time in simplefield format.
Master/Detail—If the JoinDef contains both master tables and detail tables, answer this question with y (yes) to specify simple‑field format for all data for all the master tables, and table format for all data for the detail tables. Answer this question with n (no) to display all data for all tables one record at a time in simplefield format.
Table-field format is particularly useful for Master/Detail joins, where many detail rows in the table field can correspond to a single row in the master table.