>>>Sorry folks, I could find the answer to this one in the VFP help...
>>>
>>>How do I reference fields in a table by field# rather than the name of the field. I will be doing this from a report and not in the SQL.
>
>>FIELD(lnI) <- returns the name of field number lnI in the table.
>
>>Both of these can take a work area name or number as optional parameters.
>
>I knew this part :-), how do I now reference a field in a report?
>
>Is it something like...
>
>myalias.(field(1))

if you are pointing to myalias then all you have to do is eval(field(1))
I am not sure how you would use this not pointing to myalias but the syntax would be eval('mtalias.'+field(1,'myalias'))