Seek on Recordset

[Marius Cabas]

How can I call 'Seek' on a recordset that contains two tables?

[vin]

I suggest instead of using seek, using SQL statement. SQL engine will use indexes if there are such so I don't see why you should use seek.


First you have to set relationship between
the two tables. Primary-foreign keys.

Then you can open the table with an
SQL query that joins then two tables,
of course you will use some logic to
extract the rows you need.

This way you will obtain recordset that holds
the fields from the two tables and you will easily retrieve the information you need.

[Iouri]

I agree with vin and I think that SQL will work faster than Seek

Iouri Boutchkine
iboutchkine@hotmail.com