>As far as I can tell (without running it right now), this should throw an error unless there is a field1 in the table in work area 2. We've been discussing that ENDSCAN automatically re-selects the alias associated with the SCAN. If your code works, then it implies that the re-select took place before the ENDSCAN (unless you are using the alias.fieldname which is not apparent from the above).

Sorry, my fault, I was doing a quick cut & paste for the example code & didn't notice I'd misplaced the paste, ? field1 should be above select 2.

Thanks for reminding me about using the PRE tags for formatting the code - one day I'll remember.