Hi,
 Here is the problem:
  I have two ComboBox's. I am trying to do a drill down based on the selection of each box. For example, I get the data for CB1 from the database and fill it.If CB1 is let's say..project_id and I select one project_id, I want CB2 to be filled with Group_id's for that project. Finally after all the selection's are made I want the data of Group_Id selected in CB2 to be displayed in a DataGrid.
 Here is what I did:
  I tried passing the parameter in Fill(), but for some reason I do not get any data. I am using a SQL Server2000 DB.

I am still stuck at the first step:(

Thanking you in anticipation for a solution :D

----

Distributed computing ->Causality-> EventDriven ->We have the last laugh.!!

__________________
----

Distributed computing ->Causality-> EventDriven ->We have the last laugh.!!

I have half of the solution to your problem. I'm hardtime to get the valuemember of my second box. The code is in VB with Acces DB.
"
 Dim ds As New DataSet
        Dim cmdString As String = "select * from project"
        Dim da As New OleDb.OleDbDataAdapter(cmdString, con)
        da.Fill(ds, "project")

        cmdString = " select * from group"
        da = New OleDb.OleDbDataAdapter(cmdString, con)
        da.Fill(ds, "group")

        Dim relation As New DataRelation("ProjectGroup", _
                    ds.Tables("project").Columns("project_ID"), _
                    ds.Tables("group").Columns("project_ID") _
                    )
        ds.Relations.Add(relation)

        cb1.DataSource = ds
        cbOrg.DisplayMember = "tblProjectGroup.ProjectGroup_Name"
        cbOrg.ValueMember = "tblProjectGroup.ProjectGroup_ID"

        cbAccount.DataSource = ds
        cbAccount.DisplayMember = "tblProjectGroup.ProjectGroup.Group_name"
        cbAccount.ValueMember = "tblProjectGroup.ProjectGroup.Group_ID"

"
I hope this will help you....

Thank you! that looks promising. Let me try it and see if i can get the data into the second one as well


----

Distributed computing ->Causality-> EventDriven ->We have the last laugh.!!