Previous  Next          Contents  Index  Navigation  Glossary  Library

Master-detail Relations

Master-detail relations are an association between two blocks--a master block and its detail block. As in the relationship between the Batch and Journals windows in your Oracle General Ledger application. Each batch (master record) is associated with a set of journal entries (detail records).

When two blocks are linked by a master-detail relation:

For example, when you display a different record in a master block, the detail block displays the detail record(s) that correspond to the new master record. Similarly, if you perform a search in a master block, the detail block displays the detail record(s) associated with the master record that was retrieved from the search.

Master and detail blocks can often appear in the same window or they can each appear in separate windows. When querying the details may be slow (usually when they are in separate windows), an unlabeled coordination check box appears in the upper right corner of the detail block window. This check box lets you decide whether to constantly update the coordination of records between a master and a detail window when the detail window is open in the background.

Figure 1 - 37.

For example, suppose you have a master and a detail window, and the detail window displays records that pertain to the current record in the master window. If you uncheck the coordination check box and then display another record in the master window, the detail window clears itself and does not display any data until you move your cursor into the detail window. At that point, it displays the detail record(s) that match the current master record. If you check the coordination check box and display another record in the master window, the detail window automatically refreshes to display the detail record(s) that match the current master record.

Note: When you first open a detail window or when you query a new record in the master window, the detail window always updates to display the detail record that matches the current master record regardless of whether the coordination check box is checked or unchecked.


         Previous  Next          Contents  Index  Navigation  Glossary  Library