Hello,
I was wondering if a datagrid in VB.Net can show subtable data. for example, If I load both the 'Northwind' Customers, and Customer_orders tables into a dataset, and then set the primary keys for both tables in the ds, can I do a datagrid that does some sort of branching, showing the customer data, and then clicking a 'branch' to open the subtable customer_orders data corrosponding to the customer record I've just clicked to open.
This would be very simular to a MS Access table feature. When there is a relationship between two tables, it will have a + sign that can be clicked to show the subtable data.
Any ideas would be appreciated.
Thanks
McDoogle
I was wondering if a datagrid in VB.Net can show subtable data. for example, If I load both the 'Northwind' Customers, and Customer_orders tables into a dataset, and then set the primary keys for both tables in the ds, can I do a datagrid that does some sort of branching, showing the customer data, and then clicking a 'branch' to open the subtable customer_orders data corrosponding to the customer record I've just clicked to open.
This would be very simular to a MS Access table feature. When there is a relationship between two tables, it will have a + sign that can be clicked to show the subtable data.
Any ideas would be appreciated.
Thanks
McDoogle
