Report from related tables
I have the following tables:
Their relationships are:
DocP -> FormDocP (Parent -> Child1)
DocP -> DocS -> FormDocS (Parent -> Child 2 -> GrandChild)
DocP::__kpDocPID = FormDocP::_fkDocPID
DocP::__kpDocPID = DocS::_fkDocPID
DocS::__kpDocSID = FormDocS::_fkDocSID
I have a layout based on the FormDocP table where I can pull out the fields from the DocP & FormDocP tables and generate a report.
I have a layout based on the FormDocS table where I can pull out the fields from the DocS & ForDocS tables and generate a report.
My goal is to have a report with the following fields from the 4 tables:
A layout based on the FormDocS table pulls out the Name field from the tables: DocP, DocS and FormDocS, but NOT from the FormDocP table.
The Parent -> Child linear relationship is true for DocP -> DocS -> FormDocS table, but the branch DocP -> FormDocP is not resolved when the layout report is created from the FormDocS context.
My question is: how to setup layout report for the following fields:
Is there a way to merge the following two reports:
Report from the FormDocP table
Report from the FormDocS table
Thanks in advance for any guidance.