>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.
IMHO I don't see any particular problem. Any time you want to go to another area use
SELECT alias2
SET ORDER TO TAG tag_name
SEEK alias1.fieldX
When you finished return to initial area
SELECT alias1
and continue scanning here
Edward Pikman
Independent Consultant