Master Detail with Left Join
Hi qordk
I use a TfrxADOQuery and TfrxADOTable. In Page1 TfrxADOQuery is linked MasterData1 and TfrxADOTable with DetailData1.
In TfrxADOTable I used the property MasterFields with the index fields Tabelfield1 = Tabelfield2.
My problem is that this combination represents a 1:1 relation.
However, to display all the data, I need a left join field link from TfrxADOQuery to TfrxADOTable.
How do I create a left join link in FastReport?
About the property "MasterFields" TfrxADOTable this is not possible.
Do you have any example?
Thanks for your help
I use a TfrxADOQuery and TfrxADOTable. In Page1 TfrxADOQuery is linked MasterData1 and TfrxADOTable with DetailData1.
In TfrxADOTable I used the property MasterFields with the index fields Tabelfield1 = Tabelfield2.
My problem is that this combination represents a 1:1 relation.
However, to display all the data, I need a left join field link from TfrxADOQuery to TfrxADOTable.
How do I create a left join link in FastReport?
About the property "MasterFields" TfrxADOTable this is not possible.
Do you have any example?
Thanks for your help
Comments
this does not make any sense.
you would set table1 master to query1 and in table1 masterfields select one field from master one from detail
if the table is indexed you should set the index properties as well
Thank you for the example.
Their example has the same problem. Cust. No.. 3055 from the customer table is not displayed. This is exactly the problem that I have.
There is no detailed record exists for the Cust. No.. 3055.
When creating a new master record also equal to an empty record details could be created
and the problem would be solved. For more complex queries would be the same problem again so far.
Is your example the only possibility, to view master / detail records?
Thank you and best regards.
Ren?©
There is no detailed record exists for the Cust. No.. 3055."
why did you not say that in the first place?
set the masterband property printifdetailempty.