Published 16. November 2018
Updated October 2025
Navigating complex relational data is often tricky, especially when parent and child tables must stay synchronized. Master-detail browsing helps by linking a “master” record to its dependent “detail” records so you can see changes instantly. KeepTool makes this seamless, offering a unified interface that keeps master and detail views in sync as you work.
In KeepTool’s interface (typically under “Data” → “Master Detail”), you define which table is master and which is detail. Once set up, selecting a row in the master table automatically filters the detail table to show related rows. As you scroll, edit, or move through master records, the detail view updates live.
Master/Detail data view in Hora’s data content browser
Under the hood, KeepTool issues SQL queries that join or filter based on foreign key relationships. It ensures the detail query always uses the current master key value, so detail records remain contextually relevant.
Because the master and detail views are connected:
Edits or inserts in either view are reflected immediately in the other, provided foreign key constraints remain valid
When you insert a new detail row, KeepTool supplies the proper master key automatically
If you switch the master record, KeepTool ensures pending changes are committed (or rolled back) so the data remains consistent
This tight coupling reduces errors, ensures referential integrity, and lets you work more productively.
Master-detail browsing shines in many scenarios:
Form-style data navigation: View one master record and its details side by side
Hierarchical grouping: Drill into parent-child relationships without switching screens
Framing queries and analysis: Focus on subsets of data contextual to a master record
Speed and safety: Avoid writing custom filters or handling foreign keys manually
For developers, DBAs, and power users, this feature accelerates data workflows and reduces boilerplate SQL.Oracle-Tools
Open your KeepTool / Hora application, choose “Master Detail” mode, define your master-detail relationships, and try browsing. See how selecting parent rows automatically updates child views, maintaining context without extra effort.
KeepTool's Oracle tools are designed specifically for developers, DBAs, and support teams.
Based on over 25 years of experience, we continuously optimize our software to make your database analysis and documentation faster, more efficient, and clearer.