haider2016

Related records

Discussion created by haider2016 on Oct 10, 2016
Latest reply on Oct 10, 2016 by haider2016

Hello there,

 

I have two tables TAB1 and TAB2. Each record in TAB1 has 3 related records in TAB2. Moreover, there is a field in TAB2 called FLD2. I want to print the field FLD2 in all related records in one rows in a list view report as follows:

 

recno   FLD2  FLD2  FLD2

1  20  30  74

2  90  43  87

3  60  55  34

 

 

 

where: recno is a filed in TAB1 , FLD2s are the required fields from the related records to print.

 

 

I would be greatly appreciated it if someone help me to do this.

 

Regards.

Outcomes