Display records... 1

[shaddow]

I have two tables
tblProducts
id Number
name Text

tblData
name Text
field1 Text
field2 Text

i have an relation one to one on the name field on both tables.
I want to display the values from field1 and field2 refered to the name i chose from the combobox. Hope you understand what i ment to say... ________
George, M

 

[rbowes]

First, is there a reason that you don't have ID in the second table? Names are easy to duplicate.

Anyway, I would use a multicolumn combo with a rowsource set to a SQL statement "Select Name, Field1, Field2, ID from tblProducts, tblData
Where tblProducts.[Name]=tblData.[Name]"

set columncount = 4, columnwidths = 1";0";0";0" (to hide the other three columns. On MyCombo_afterUpdate() place this code:

With Me
If Not IsNull(.MyCombo.Value) Or (.MyCombo.Value <> &quot;&quot Then
'Push the value of the columns into the textfields
.MyText1.Value = .MyCombo.Column(1)
.mytext2.value = .mycombo.column(2)
End If
End With

that should work

Hope that helps.

Bob

 

[shaddow]

Thanks, it works, and is so simple, i dont even use another querry i use the same querry but other fields... ________
George, M