AnsweredAssumed Answered

Report from related tables

Question asked by NaturSalus on May 8, 2011
Latest reply on May 13, 2011 by NaturSalus

Title

Report from related tables

Post

Hello,

I have the following tables:

DocP

FormDocP

DocS

FormDocS

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:

DocP::Name

FormDocP::Name

DocS::Name

FormDocS::Name


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:

DocP::Name

FormDocP::Name

DocS::Name

FormDocS::Name

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.

Outcomes