In VFP 5.0 I've been working on trying to make specific needs on a report to work for about a month now unsuccessfully. Rather than tell you all the ways I have tried I'll set up the backbone and what I'm looking to do.

I have a table called "Jobs". 2 of its fields are JobDate and WeeksEnd. When info is entered for the table Jobs from a grid form each record has the appropriate day's date and the end of that week's date entered. Also there is another table called "DateHeader" which has, not only the same 2 fields as above, but other fields specific to that JobDate. In other words, the table Jobs has multiple entries (records) per JobDate and the table DateHeader has only one entry (record) per JobDate. So, as an example, the table Jobs could have 5 entries (records) per JobDate X 7 days for that accosiated WeeksEnd = 35 Jobs' records for that WeeksEnd & the table DateHeader would have 1 entry (record) only for each day of that WeeksEnd = 7 DateHeader's records for that WeeksEnd. What I need to do in the report in question is to first, group by WeeksEnd all of the table Jobs' records for that week (the 35 records as in the above example) -- that's easy. Second, what I'm having trouble with, in the group footer for that WeeksEnd show all the table DateHeader's records for that WeeksEnd (the 7 records as in the above example). Then move on to the next WeeksEnd group and so on, and so on...

I have tried everything I can think of including Parent/Child/1-to-many, Views, & even Object Classes with UDFs. I might be making this too difficult and hopfully there's an easy way that I have overlooked.

I'd appreciate any helpfull tips/directions that you might have to offer!!!

Thanks in advance,
Craig