Barbara, any view (parameterized or not) will always create a temporary table NOFILTER is for use with regular SELECT SQL cursors Arnon >Given all this hassle, why don't you use a parameterized view instead of a >filter. If you're using VFP5, use the NOFILTER clause, and if VFP3 add a >'nonsense' field to force a cursor not a filtered table. Then your >reccount() and Recno() values are always correct. > >HTH >Barbara > >