Does your report call any UDFs or methods that happen to switch the current table, or move the record pointer of the ship-to table, or anything like that?

Try adding some dummy objects to the report to show where the record pointer is in both tables and the relation that is defined. This will help you see if it changes between the first and second page.


>Hi all,
>
>I've got a report set up for printing orders. The main table has several related tables:
>
>ord_head (main table)
>ord_line (for the detail)
>salesmen (uses ord_head.slsmn_no to show salesmen.slsmn_name)
>terms (uses ord_head.terms_code to show terms.terms_desc)
>ship_via (uses ord_head.via_code to show ship_via.via_desc)
>ship_to (uses ord_head.cust_st to show ship_to.address1, ship_to.address2, ship_to.address3, ship_to.address4)
>
>Now, this is just fine for all of the data being displayed on the first page of the order. But the second page of orders doesn't show the data from the ship_to table. I'm still seeing the data from salesmen, terms and ship_via, but nothing from ship_to.
>
>From what I can see, the relations are set up exactly the same with ship_to as they are with the other tables. So, why would this one table not display data after page one when the others do? Any suggestions on what I could look for?
>
>Thanks very much!
>
>John