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