Ian,
I'd use a SCATTER NAME object to do this sort of thing.
select Table1
scatter name this.oFields memo
.... manipulate and store this.oFields.Field1
select Table2
scatter name this.oFields memo
.... manipulate and store this.oFields.FieldA
oFields will will have a property that corresponds to the workarea selected at the time of the scatter.
>I am storing values until I write the record then wanted to remove them as the next recod may not be storing the same data. I believe I have the array solution working now so that should work o.k.