>>Hi - I have a big problem...
>>
>>I am trying (still) to print a three teir invoice - with suggestions from various UT members I am getting close BUT
>>
>>I have the main info in a view and the data grouping is set to item description within deliverynote within customer. That's fine but I have the summary details that need to appear at the top of the report - this is a temp table with one of the fields being a memo field per customer that I want at the top. What I getting is the first customers memo field for all the customers - it's as if the record pointer is not moving in the second table - how can I get it to move to the correct customer in both tables?
>
>
>You could approach this a couple different ways. One way is to use SET RELATION and/or SET SKIP to get the record pointers to coordinate (if you have indexes set).
>
>A second way is to use a UDF in the report. You can create a procedure called something like SETCUST in the program that calls the report or in a procedure file that is available. In this procedure, select the customer table and then SEEK or LOCATE to find the right record. be sure to put the current alias back to the one that drives the report. In the report, put SETCUST() in the On Entry portion of the band that you are printing this information. If you happen to be using 2.x instead of VFP, you can accomplish this by putting a field in the band and using SETCUST() as the expression - just be sure to use SendToBack to make sure that this is the first thing processed in this band.
>
>Hope this helps,
>Cathy

The third way is to SELECT all of the data into one cursor and use that. I see more debugging problems posted by people using related tables. So many of these problems are eliminated by making one denormalized cursor.

Chris, if you do this, take the "MyTable." out of the report controls and just use "MyField" .