General information
Category:
Reports & Report designer
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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only