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.