>>>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.
>
>
>Thanks, I will take a look at the udf idea.
>
>jd

Antoher way, maybe simpler to implement in your case, is to move data from tables with different structure to a cursor with fixed structure and then print from this cursor.