I have to TZQuery components.
They are providing data from two Master- Detail tables.
It looks like this:
select * from table1 where index = 1;
select * from table2;
These two TZQuery are connected together via MasterSource, MasterFields, LinkedFields and IndexFieldNames.
It works fine but slowly.
I wonder if I could make it work faster...?
Maybe I should avoid queries like:
select * from table2?
What is the best practice to realize this master- detail connection?