>I am USEing a table, SCANning it, and in the scan performing a SELECT on another table using a value from the first as the search key. How do I specify an index for the second table?
> I have only used work areas limitedly and am not completely comfortable yet, should I be using the tables in different work areas? I never opened the second table anywhere except in the select statement.
>
>By the way- Thanks to everybody for all your help with my sometimes silly questions in the past. As a VFP beginner, I feel I would be stuck out on a limb without your help. This is especially aimed at Edward, Dave, Arnon, and everyone else who has been quick to respond to my problems.

So, I'm assuming that the code looks something like:

Sele 0
Use FILE1
set order to tag TAG1
go top (or seek initvalue)

SCAN
SELECT fieldlist;
from FILE1,FILE2;
where FILE2.idfield = FILE1.idfield
into RESULTFILE
(manipulate RESULTFILE)
ENDSCAN

If my assumption is correct, you don't need to specify an index tag on the second file. Fox will determine if an index tag that it needs for he select exists and will use it. For Rushmore to work properly, you don't want ANY index tag active on the second file.