General information
Category:
Forms & Form designer
Title:
2 related tables in 1 grid
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only