I assume you want to use a table so that it can be updated during the process. If so, try this:
vc=sys(2015)
SELECT (your select code) INTO table (vc)
if _tally=0
=messagebox('There are no customers that match this criterion...')
use in vc
todelete=vc+'.dbf'
delete file &todelete
return
endif
use (vc) again in 0 alias MyAliasName
This will give you diff tables for each user but the code all refers to whatever alias you use. Be sure to delete the file when you finish.
A problem is a problem only as long as it has a possible solution. Lacking that, it becomes a FACT!
