seek or find method

[luca90]

i have a connection on MyMdb.mdb with table1 and table2
each table have a filde named COPE
is possible to use the seek method or find method (i dont know wat is the best) simultanious on the 2 table in filed COPE????

or... seek first on table1 and after seek on table2...

[si_the_geek]

If the two tables are linked in some way, why not join them in your recordset (or whatever it is you are using)?

You can load the data like this:

SELECT table1.*, table2.*
FROM table1
INNER JOIN table2 ON table1.Cope = table2.Cope

.and if you only want a specific value of Cope, specify that in a Where clause:

SELECT table1.*, table2.*
FROM table1
INNER JOIN table2 ON table1.Cope = table2.Cope
WHERE table1.Cope = 3