Hi Everybody,

I am developing an application which will be run by 100+ users. From a single master table located in a server, the user application needs to get a single record but this record comes from a filtered subset of the entire master table. Each user/workstation needs to get its record in less than a second. The master table is just plain ordered according to its sequential arrangement - meaning by record number (RECNO()).

The SQL syntax I tried is something like this:

"SELECT TOP 1 RECNO() AS RECORDNO, * FROM Mastertable WHERE Taken=.F. ORDER BY RECORDNO"

I tried using local views, remote views but it takes MINUTES(!) to execute (to return the first 'available' record that is). Am I missing out on anything?

My advanced gratitudes to anyone who will look into this!