how to access a field of one table from the other table in a database

[yashumrhsn]

hi....
its very urgent.... i have a 2 tables in table1 contains 2 fields-username(text) and points(number) and table2 contains points(number) and image(attachment)
fields.... what i want is, the form contains a combobox, when i select the particular points of a user it should display the points with images in a form...

eg: points(table1): 20 and points(table2):5,10,15,20,25,30

images(table2):img1,img2..................

when i select d points of table1 in a combobox then it should display the points of table2 ie 5,10,15,20 and the corresponding images in a form....
plz help me...........
frontend:vb6.0
backend:access2007
i am using adodb

[debasisdas]

That can be done simply byusing SQL .

Pass the value of first table in the where condition to query the second table.

[rekhasc]

That can be done simply byusing SQL .

Pass the value of first table in the where condition to query the second table.

sql= select table1.points,table2.points,table2.images from table1,table2 where table1.points=" &combo1.text
i tried this query but its not displaying the all the points which are present in table2

[yashumrhsn]

sql= select table1.points,table2.points,table2.images from table1,table2 where table1.points=" &combo1.text
i tried this query but its not displaying the all the points which are present in table2

i tried this query,but from this query am not getting..its not working..if any one know the query for this plz give me the correct query its very urgent and also it should show the points of other table and also the corresponding images in the form.........

[debasisdas]

Is there any relation between these two tables.

[9815402440]

hi
try this logic

dim rstT1
dim rstT2

open both recordsets

use following command to filter records in rstT2
rstT2.Filter = "Points = " & rstT1.fields("User").value & ""

with rstT2
.movefirst
while not .eof
debug.print .fields("Image").value
.movenext
wend

end with


regards
manpreet singh dhillon hoshiarpur

[daveftl]

sql= select table1.points,table2.points,table2.images from table1,table2 where table1.points=" &combo1.text
i tried this query but its not displaying the all the points which are present in table2

try this:

SELECT table1.point, table2.image FROM table1, table2 WHERE table1.point = table2.point