Hi all:

My report will require information from 3 different tables. Currently, the way I am approaching it is:

1. Select * from table1 into cursor curTable1
2. Select * from table2 where a field in table1 matches a field in table2 into curTable2

In the report, I placed the client name in the header (did not create groups), since the report is for a specific client and for a specific date. In the detail section, I placed labels for the fields and linked them to fields in curTable1. The display was OK to this point.

Then I added a field in the report and linked it to a field from curTable2. At this point, the report showed all of the info from curTable1 and one value from a field in curTable2. Then, it followed by repeating the fields from curTable1 and then displayed the new value for a field from curTable. I do not want curTable1 field repeating each time.

Any suggestions? TIA.

Ravi