Hi, i am writing a Vb.net program where i want to display records from three different Sql tables of same database. suppose i have table1 with Topic, table2 with Category and table3 with Ideas. each topic has many categories and each category has many ideas. my table relationship is one-many between Ideas and Category, also one-many between Category and Topic.

my question is how do i display all these in a table on a webpage...
i would like the result to be like...
__________________________________________________ ___________________
"TOPIC 1"
__________________________________________________ ___________________
Category "1"
       Idea "1"
       Idea "2"
       idea "3"

Category "2"
       Idea "1"
       Idea "2"
       Idea "3"

category "3"
       Idea "4"
       Idea "5"
       Idea "5"
__________________________________________________ _________________
and so on.....
my main purpose is to display Category and idea but i can't seem to get the commands right.
__________________________________________________ _________________
my Topic Table has fields UID, Topic
   Category Table has UID, Category, BelongTopicUID
   Idea Table has UID, Idea, BelongCategoryUID
__________________________________________________ _________________
i hope that you all good people can help me out with this problem. i am really desperate and tried it for a long time but could not get it right. Thanking you all in Advance...

Please post some code. It is difficult to help if you don't show what you have

 Function AddTable()

        Dim i As Integer
        Dim AddTableDR As System.Data.SqlClient.SqlDataReader
        SqlConnection2.Open()
        AddTableCMD.CommandText = ("select StormCategory_1.CategoryName, StormHeading_1.Heading, StormHeading_1.Idea from StormCategory_1 INNER JOIN StormHeading_1 on StormCategory_1.uid = StormHeading_1.BelongCategoryID WHERE StormCategory_1.BelongToTopic = '" & list & "' ORDER BY StormCategory_1.CategoryName")
        AddTableDR = AddTableCMD.ExecuteReader()
        AddTableCMD = Nothing
        With AddTableDR
            Dim oldcategoryname
            If .Read Then
                Do While .Read
                    If .Item("CategoryName") <> oldcategoryname Then
                        oldcategoryname = .Item("CategoryName")
                        Dim NewRow As New TableRow
                        'New cell
                        Dim NewCell As TableCell
                        NewCell = New TableCell
                        NewCell.Text = "<b><H2>" + .Item("CategoryName") + "</H2></b>"

                        NewRow.Cells.Add(NewCell)
                        Me.Table3.Rows.Add(NewRow)
                    End If
                    Dim NewRow1 As New TableRow
                    'New cell
                    Dim NewCell1 As TableCell
                    NewCell1 = New TableCell
                    NewCell1.Text = .Item("Heading")
                    NewRow1.Cells.Add(NewCell1)
                    Me.Table3.Rows.Add(NewRow1)
                Loop
            End If
            .Close()
            AddTableDR = Nothing

        End With
        SqlConnection2.Close()
    End Function

the above is the code that i used to display two tables. but it's displaying one record less, it was suppose to 14 records but it is displaying only 13. also, this is only two tables, how do i add another table called "Comments" which has one to many relationship between Heading and Comments.
Thanks....