Hi!
Yes, it is possible. You just need correctly specify aliases in the ControlSources property of columns. Say, you have following related tables:
Delivery
|
|_Details
Grid.RecordSource = "Delivery"
Grid.Column1.ControlSource = "Delivery.dDate"
Grid.Column2.ControlSource = "Delivery.Customer"
Grid.Column3.ControlSource = "Details.Product"
In addition, when you set on-to-many relation (using SET SKIP TO command), grid will show all records from details for one record in Delivery.
>It is possible to fit in 2 table data into single grid?
>
>example :
>
>1 table contain item detail and 2nd contain deliver informaion.
>
>So I set the relation in dataenvironment of the form and fill the grid with data from 2 table.
>
>But it is not work. Why?
>
>Thank in Advance.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.