SQLMemTable: BDE Alternative Embedded
In-Memory Database with SQL for Delphi / C++Builder
Specifies the name of the data source for a dataset to use as a master table in establishing a detail-master relationship between this table and another one.
property MasterSource: TDataSource;
Use MasterSource to specify the name of the data source component whose DataSet property identifies a dataset to use as a master table in establishing a detail-master relationship between this table and another one.
MasterSource may be any DataSource, not only SQLMemTable.
Note: At design time choose an available data source from the MasterSource property's drop-down list in the Object Inspector.
After setting the MasterSource property, specify which fields to use in the master table by setting the MasterFields property. At runtime each time the current record in the master table changes, the new values in those fields are used to select corresponding records in this table for display.
Note: At design time, use the Field Link designer to establish the master-detail relationship between two tables.