Why not just use a view constructed from both tables?

>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