I looked at my database again. Corrected some errors. The sub tables are one-to-many relationships with the main table. It does not look as if what i want to achieve will work. I do not want the datagridview to display more than one record per item. What i am also doing is exporting my datagrid to excel. Here is the code (It exports the main table perfectly). If you could perhaps help me modify my code to ADD the additional columns from the sub table records to the excel spread sheet, that will also solve my problem because it will be used mainly for pivots and printing. The vb is merely a front-end for capturing and displaying the data and i thought it would be easy enough to just add the extra columns to the datagridview, because my export to excel already works very well. Thanks very much for your help so far. Private Sub btnExport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnExport.Click 'Verfying the datagridview has data or not If ((DataGridView1.Columns.Count = 0) Or (DataGridView1.Rows.Count = 0)) Then Exit Sub End If 'Creating dataset to export ds = New System.Data.DataSet 'Add table to dataset ds.Tables.Add() 'Add column to the table For i As Integer = 0 To DataGridView1.ColumnCount - 1 ds.Tables(0).Columns.Add(DataGridView1.Columns(i).HeaderText) Next 'Add rows to the table Dim dr1 As DataRow For i As Integer = 0 To DataGridView1.RowCount - 1 dr1 = ds.Tables(0).NewRow For j As Integer = 0 To DataGridView1.Columns.Count - 1 dr1(j) = DataGridView1.Rows(i).Cells(j).Value Next ds.Tables(0).Rows.Add(dr1) Next Dim excel As New Microsoft.Office.Interop.Excel.ApplicationClass Dim wBook As Microsoft.Office.Interop.Excel.Workbook Dim wSheet As Microsoft.Office.Interop.Excel.Worksheet wBook = excel.Workbooks.Add() wSheet = wBook.ActiveSheet() Dim dt As System.Data.DataTable = ds.Tables(0) Dim dc As System.Data.DataColumn Dim dr As System.Data.DataRow Dim colIndex As Integer = 0 Dim rowIndex As Integer = 0 For Each dc In dt.Columns colIndex = colIndex + 1 excel.Cells(1, colIndex) = dc.ColumnName Next For Each dr In dt.Rows rowIndex = rowIndex + 1 colIndex = 0

I'm not sure what it should be now. In the relationship diagram it says one to one. There is only one product-id in the main table. In the sub tables, the same product-id can occur many times, but with with different category groups for instance. So essentially, it is a one-to-one relationship. Don't forget i am trying to prevent multiple records in the main table when i add product categories, because the same product can occur in a number of categories. So the categories will be stored in a separate table with the same product-id. But when i display the datagrid, i want to only display one line per product-id, but with each category in a separate column.

Thankyou, I have now done all 5 steps. What next?

I am using VB.Net 2008 with an access database and i am using a TableAdapter to fill the datagrid. I am new to vb and do not now how to code for this. What i do have so far is that my program is working fine loading the datagridview from a single table. To link to the sub tables and add a column for every row of the sub table is my problem - i do not know how to code it. Here is my code so far: ' Iniatilize Connection cn = New System.Data.OleDb.OleDbConnection( _ "provider=Microsoft.Jet.OLEDB.4.0; " & _ "data source= " & Directory.GetCurrentDirectory & "\XXXDatabase.mdb") 'Populate Members DataGrid da = New System.Data.OleDb.OleDbDataAdapter("SELECT * FROM XXXDetails", cn) ds = New System.Data.DataSet da.Fill(ds) DataGridView1.DataSource = ds.Tables(0) cn.Close()

Please Help Me - Urgent How Do I Add A New Column For Each Record From A Table To An Existing DatagridView I have 3 tables. Each table has a common unique key field linked to the main table. I want to populate a datagridview with the contents of all the tables. For each record in the 2 sub tables, i want to add a new column in the datagridview. TABLE 1 TABLE 2 TABLE 3 Prd Dsc Qty Prd Cat Prd Loc 123 MyProd 10 123 Perishable 123 Fridge 1 123 Fridge 2 123 Fridge 3 DATAGRIDVIEW Prd Dsc Qty NewCol - Cat NewCol - Loc NewCol - Loc NewCol - Loc 123 MyProd 10 Perishable Fridge 1 Fridge 2 Fridge 3