There will be around 10000 records. This grid is on
my startup form so it would take too long to load.
Thanks for the tip on the pre tag.
>Joe,
>The easiest way is to use a view for the grid unless there are hundreds of records. You might also play around with Sparse in Column 3 to see if that helps. I've had similar problems and almost always switched to views. There's a similar problem in grids with related tables that sometimes causes one value to repeat when you scroll through a long list.
>
>Note also the < pre > and < /pre > tags I added to show your data more clearly. To see exactly how they're used just click the 'reply' button.
>
>Barbara
>
>>I have a relation set up between two tables and have fields from each
>>in a single grid. The relation is set in the DE.
>>
>>Grid.RecordSource = "order"
>>Grid.Column1.ControlSource = "order.ordernum"
>>Grid.Column2.ControlSource = "order.total"
>>Grid.Column3.ControlSource = "customer.name"
>>
>>This almost works except here is what it shows...
>>
>>ordernum total name
>>1 100 Joe
>>2 350 Mike
>>3 50 MiKe
>>All of the orders are for the same person. It picks up the
>>first record of customer for the grids first row. The data
>>is correct in the table and it all looks ok when using two
>>browse windows. What's going on?
>>
>>vfp5.0