Kriterier

SELECT table1.ID, table1.Field1, table2.ID, table2.Field1
FROM table1, table2
WHERE (((table1.ID)=3) AND ((table2.ID)=4));

Just something you should think about! I am only assuming that the ID (autonumbers) are in sequence starting from 1, but this may NOT always be the case. If records get deleted or even when a record is getting added but the actual update isnt carried out, then the numbers will NOT be sequential.