Intro

If you’re developing in Delphi and looking for a powerful, flexible, and highly customizable data grid solution, then TMS FNC Data Grid is the perfect choice. In this blog, we continue on our journey with the TMS FNC Data Grid. The TMS FNC Data Grid offers developers advanced tools for presenting and interacting with data. Master-Detail relationships is a feature to create intuitive and synchronized data representations, where a master grid shows parent records, and a detail grid reflects the corresponding child records based on the selected master entry.

Master-Detail

By linking the master and detail grids through the adapter, the detail grid can dynamically refresh and display the appropriate records from the child table. This is achieved by setting up datasets for both tables and using TDataSource components for database linking.

Setting up Master-Detail Tables

The master-detail relationship consists of:

• Master Table: Contains parent records (e.g., `Orders`).
• Detail Table: Contains child records linked to the master table (e.g., `OrderDetails` with a foreign key `OrderID`).

Configuring Database Components

1. Create Datasets
• Create datasets for the master (`Orders`) and detail (`OrderDetails`) tables.
• Use `TDataSource` components to link the datasets (`dsMaster` and `dsDetail`).
2. Configure Database Adapters
• Place two `TTMSFNCDataGridDatabaseAdapter` components on the form.
• Set the `DataSource` of `MasterAdapter` to `dsMaster` and `DetailAdapter` to `dsDetail`.

Linking Master and Details Grids

1. Master Grid Setup
• Drop a `TTMSFNCDataGrid` component on the form and set it to display fields from the master dataset (`Orders`).
• Bind this grid to `MasterAdapter`.
2. Detail Grid Setup
• Add another `TTMSFNCDataGrid` for the detail dataset (`OrderDetails`).
• Bind this grid to `DetailAdapter`.
3. Define Master-Detail Relationship
• Set the `MasterSource` property of the detail dataset (`dsDetail`) to the master dataset’s `TDataSource`.
• Define the `MasterFields` to specify the linking key (e.g., `OrderID`).
4. Display Detail Data:
• Set the DetailControl property of the `MasterAdapter` to `OrderDetails` Grid

Custom Detail

With TTMSFNCDataGrid, you have freedom of choice, and this also applies to setting up Master-Detail relationships. In this sample, we created a panel, added a TTMSFNCDataGrid instance which is bound to a detail table, and a chart, also setup via the same detail table.

Conclusion