Displaying Columns from related tables in a Datagrid Control

[edolikian]

Suppose you have a Master/Detail type form. Order > Details. I have established a binding object for the Master to the Order table and the Details to the OrderDetails relation.

In the Details Grid, I want to display a column from a related table (e.g. Product Description). How do you do that? Don't need to be able to edit.

[enreil]

You could accomplish this by doing a simple SQL join and then using the data returned by the join as your datasource.

Suppose you have a Master/Detail type form. Order > Details. I have established a binding object for the Master to the Order table and the Details to the OrderDetails relation.

In the Details Grid, I want to display a column from a related table (e.g. Product Description). How do you do that? Don't need to be able to edit.