Why would you want to open the table connection once for each record in the table? If everyone did that, it'd kill performance. Find ALL records, then FILTER the data in the query

(Unless you do have a million records, in which case you'd load 50 filtered records at a time(