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.