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