>I have a procedure which displays records from a table depending if they match certain requirements set by the user (such date from, date to etc). When a record matches the requirements it is copied to a temporary table. This works most of the time, but, on some occasions VFP is finding itself on the wrong table and when I suspend and do a "? alias()" the name of the temporary table is printed, yet I haven't selected the temp table.
> The source below is one example:
>
>select fixtures
>go top
>do while .not. eof()
> mpos = recno()
>
>* determines whether the record should be copied to the temp table
>
> select fixtures
> go top
> go mpos
> skip
>enddo eof()
>
>An error occured on the "go mpos" saying "record out of range". I suspended and done a "? alias()" and the temp table is selected. AHHHH!, How?
>
>Many thanks to anyone who tries to help in advance.

---

Mystery seems to lie where you commented :
* determines whether the record should be copied to the temp table
Probably there is code there changing workareas. Better you could code it like :

select fixtures
scan

* determines whether the record should be copied to the temp table

endscan

This would also save you from storing mpos.
Cetin