>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.
Edward Pikman
Independent Consultant