We choose the specific record based on a field name nIDnumber; the table is indexed on this field.

This is what I tried:

OPEN DATABASE DBNAMES

CREATE SQL VIEW ViewOneRecord AS;
SELECT *;
FROM DBNAMES!RECLIST;
WHERE nIDnumber = 1234567


However, if I "DISPLAY STATUS", I find that the big table is open (as well as the database).

CM