Master-Detail Forms: Join Conditions

| Field Descriptions | Related Help Topics | Additional Information |

Use this page to choose join conditions between the master table or view and the detail table or view that you selected in the Table or Views step.

The columns shown in the two sets of combo boxes in this page are contained in the tables or views you selected. For example, a department number master column named DEPTNO in the DEPT table appears in the combo box as DEPT.DEPTNO.

To specify a join condition, choose a column from one of the left Master Column drop-down lists and a column in the Detail Column combo box directly to the right of it.

Field Descriptions

Field	Description
Master Column	Choose the master table or view column that you want to include in the JOIN condition of the SQL query used to build the master-detail form.
Detail Column	Choose the detail table or view column that you want to include in the JOIN condition of the SQL query used to build the master-detail form.

Notes

OracleAS Portal bases the default join conditions shown in this page on the tables or views you selected in the Tables or Views page or the Master-Detail Form Wizard. You can accept these or choose different join conditions.
Rows in one table may be joined to rows in another if common values exist in corresponding master and detail table or view columns.
When end users display views, updateable columns are displayed in black, non-updateable columns are displayed in blue, and required (mandatory) columns are displayed in red.

Additional Information

On Portal Center:

For more information go to the documentation section of Portal Center.

Master-Detail Forms: Join Conditions

Field Descriptions

Notes

Related Help Topics

Concepts:

Next Steps:

Additional Information

On Portal Center: