This is a feature of JBuilder Professional and Enterprise.
Use this dialog box to link two queries together in a master-detail relationship.
Select the query you want to be the master query. Your choices are the queries that are listed on the Queries panel of the Data Modeler.
Select the query you want to be the detail query. You choices are the queries that are listed on the Queries panel of the Data Modeler.
The first column of the grid is titled with the name of the query you specified as the master query. In that column, click the first row to display the down-arrow that gives you access to the list of column names in the master query. Select the column name you want to use to link the master query with the detail query.
The second column of the grid is titled with the name of the query you specified as the detail query. In that column, click the first row to display the down-arrow that gives you access to the list of column names in the details query. Select the name of the column that contains data within the same domain as the column name you specified under the master query.
The two columns you specify to create the relationship may have the same name, but that is not a requirement. The names of the columns can differ, but they must have the same domain.
Specifies when detail records are fetched. If you want detail records fetched only when each master record is visited, check this checkbox. Select this option if your remote database table is very large. Because not all of the data is held in memory, performance improves. Also, the data you view will be the most current.
Leaving this checkbox unchecked results in all the detail records being fetched at once. The records are held in memory and provide a snapshot of your data at the time the records were retrieved.
The column in the master table that links that table to the detail table is the linking column. Select the Allow Cascading Updates option when you want updates to the linking column in the master table to be reflected in the detail table. The updates are said to cascade to the detail table. If this option is not selected, updates are not reflected in the detail table; therefore the updates do not cascade.
If the query involves multiple levels of links (for example, one master table is linked to a detail table, which in turn is a master table for another detail table), set this option at each level for the cascade results to be as you expect.
Select this option when you want the deletion of a record in the master table to delete all linked records in the detail table. If this option is not selected, deletes are not reflected in the detail table; therefore the deletes do not cascade.
If the query involves multiple levels of links (for example, one master table is linked to a detail table, which in turn is a master table for another detail table), set this option at each level for the cascade results to be as you expect.