Page 1 of 1

Create master/detail over another master/detail

Posted: Mon 12 Feb 2018 20:49
by madriz1989
Hi all,
I need to create master/detail of these tables:
Image

It has a master table "SIGEV_CARGA" and its detail "SIGEV_CARGA_DET", and at the same time the detail "SIGEV_CARGA_DET" is master of "SIGEV_BOLETA_PRODUCTOR" and the last one has a detail table "SIGEV_BOLETA_PRODUCTOR_DET"..

Is it possible to configure that with the property mastersource of TUniQuery?
How can I capture the ID_SIGEV_BOLETA_PRODUCTOR to save in its master SIGEV_CARGA_DET?

Re: Create master/detail over another master/detail

Posted: Thu 15 Feb 2018 14:50
by Stellar
If you want to bind a detail dataset with several master datasets, then unfortunately there is no standard solution. TDataSet can be bound with only one master dataset using the TDataSet.MasterSource property, so it is not possible to bind a detail dataset with two master datasets. This functionality is not implemented in TDataSet, unfortunately we cannot influence this behavior.

Re: Create master/detail over another master/detail

Posted: Thu 15 Feb 2018 16:17
by madriz1989
Ok, thanks @Stellar.. I'll do it separately.