Hey Shane,
It seems this would be easier if you standardized your table structures.
Define a third table that stores the record keys from the other two tables.
That is, it stores a relationship between a Member and a Tournament.
For your report, make it your selected table and set relationships into the Memger and Tournament tables useing the 'Additive' parameter.
Create a grouping on your report that breaks on Member and put the Tournament fields in the Detail band.
You could also create a Select statement that creates a single table for the report but the effect would be the same... just different aliases for the fields.
Goo Luk!
Steve Ramsower


>I am creating a program for my Dad to keep track of the standings in his Bass Fishing Club. The number of tournaments varies from year to year so I created a function that creates a schedule table based on the Members.dbf and Tournaments.dbf. Any suggestions how to do a Report for this table that has varying field names and field counts? Is there any way to use the Report Generator or am I going to have to code this by hand? BTW, I am using VFP 3.0 for the PC.