I am trying to figure out how I can display data on a VB form that comes from several tables and can be updated. I was using an ADO data control, but it is causing me problems when I join tables.

Basically I want to display and edit...

Table1.Name
Table1.Phase
Table2.StartDate
Table2.EndDate
Table3.TypeDesc

Does anyone have any idea how I could do this? Table design is below.

[u]Table1 - Customer</u>
Customer_ID (PK)
Name
Phase
Type_ID

[u]Table2 - Phase</u>
Customer_ID (PK) - FK to Table1
Phase (PK)
StartDate
EndDate

[u]Table3 - Type</u>
Type_ID (PK)
TypeDesc

You should use a mshflexgrid not linked to any adodb control. You make a recordset from your joined tables and than fill the grid from the recordset row by row

        With rsTemp
            .MoveFirst
            i = 1
            While Not .EOF

                hfgRecords.Rows = i + 1

                hfgRecords.TextMatrix(i, 0) = .Fields("Name").value & ""

                hfgRecords.TextMatrix(i, 1) = .Fields("Phase").value & ""

                hfgRecords.TextMatrix(i, 2) = .Fields("StartDate").value & ""

                hfgRecords.TextMatrix(i, 3) = .Fields("EndDate").value & ""
                hfgRecords.TextMatrix(i, 4) = .Fields("TypeDesc").value & ""

                i = i + 1

                .MoveNext
            Wend
        End With


Lucian Preda
[email protected]

Also,

if you are familiar with SQL ("UPDATE tablename SET field = value,.."), you can build the SQL statement in form of a string and then assign it to a ADO command & execute it.

This is, in my opinion, the most straightforward and controllable way.
It also works with any SQL dialect (Oracle, MySQL, Sybase etc.)

Mike