For this purpose you can use
Master Detail relationship to display the data.
The left hand side fields you have said are to be stored in one data table say
Orders (as found in Northwind sample database of MicroSoft) as rows. Create another DataTable say
Order Details to store the data to be displayed on the right hand side. Establish a
DataRelation between these table using the
Primary Key and Foreign Key values. Say
OrderId column is present in both the tables, then the DataRelation can be established between these columns. Each row of Orders DataTable has relation to the rows in Order_Details.
Please see the following article
General purpose class to fill DataTable(s) from DataBase and to save DataTable(s) to DataBase using reflection[
^]
In demo program, under second tab page, Order and Order details, you can find a similar functionality. The article is in C# but you can convert the code to VB.NET using the online converter
http://converter.telerik.com/[
^]
Submit an article or tip