Printable View
I am using an access backend and DAO for this program.
I am trying to do a search on a home phone number that will bring up four recordsets that go with this home phone. I know how to do a search on just one recordset, but have no idea how to do this with four recordsets.
Please help me!
Create fifth recordset, append all records from 4 recordsets and make your search. Or make your search in a first recordset, if nothing found then in a second one and so on.
Vlad
Faster than brute force method of searching all recs would be to create an new record with INNER JOIN or its variants..
Ex from MSDN:
SELECT fields
FROM table1 INNER JOIN table2
ON table1.field1 compopr table2.field1 [AND
ON table1.field2 compopr table2.field2 OR
ON table1.field3 compopr table2.field3)];
compopr: is a comparision operator, like <, > , <=, etc
RK