Evan & Barbara

Thanks for your help.

I fixed the problem by just doing one INNER join select to a cursor, that way didn't have to address field alias' at all.

Regards
Doug Johnston


>Doug,
>
>If your code is
>
>SELECT....to cursor t1alias
>
>then you just refer to them as t1alias.FieldName. If for some reason you need the exact file name of the cursor (If you need to append from the cursor, for example) then you can refer to the file with dbf('t1alias')
>
>HTH
>Barbara
>
>>Hi,
>>I have two .dbf files created by a SELECT, I have stored their alias' to t1Alias and t2Alias.
>>
>>How do I reference these alias's in the report writer. I have tried &t1Alias..fieldname but this doesnt work.
>>
>>I look forward to some help here.
>>
>>Regards
>>Doug Johnston