If you know the order of the fields, (the key field is always field #1) you could use EVAL(FIELD(1))
>>I have a program that needs to report on information from a table, but the system will not be informed of the layout of the table until runtime. I have tried everything I know to set it up so that the reporting routine works regardles of the name of the fiels using macro susbstitution. So far nothing has worked. Any hints?
>>
>>Thanks in advance...
>>
>>
>>John Dennis
>
>I guess you may use UDFs. For example, use as field expression "GetMyField1":
>FUNCTION GetMyField1
>DO CASE
>CASE Alias()="TABLE1"
> Return table1.field5
>CASE Alias()="TABLE2"
> Return table2.field8
>*** etc.
>ENDCASE
>
>Instead of Alias(), you may check something else, e.g. FCOUNT(), whatever is more appropriate for your design, some pre-set variable in ultimate case.
--Todd Sherman
-Wake Up! Smell the Coffee!