populating a DB Grid With Columns from 2 different tables

[newora]

Hi There,

I have been trying to protype this for a few hours and do not seem to be getting anywhere, so could someone please help point me in the right direction.

I have a DB table that has 2 columns in it - I only wish one of these columns to be displayed in the DB grid. I also want another column in the DB grid that contains a column from another DB table. I am OK with doing this, but my problem comes when I want to make the second DB grid column a drop down list, based upon the contents of a column from a second db table.

eg.

Column1 column2
dbtbl1.machinename dbtbl2.fault_reasons(dropdown)

Any pointers would be most welcome

 

[Andrzejek]

First, I would populate a combo box set to DropDown List style:

rst1.Open "Select fault_reasons From dbtbl2", Cn

cboFault.Clear
For i = 1 To rst1.RecordCount
    cboFault.AddItem rst1!fault_reasons
    rst1.MoveNext
Next i

rst1.Close
cboFault.ListIndex = 0

And then in cboFault_Click event I would populate grid:

rst1.Open "Select machinename From dbtbl1 Where Col2 = " & cboFault.Text, Cn

Grid.Clear

for i = 1 To rst1.RecordCount
    grid.additem rst1!machinename 
    rst1.MoveNext
Next i

HTH

---- Andy

 

[newora]

Hi, Thanks for that - it has certainly put me on the right track.