>>in the report designer (actually i am in query maker, but it is the same concept), and the client adds a new field to the report. up pops Report Expresson window. client clicks on Expression Builder. would like to see the fields of my query result set displayed in the Fields list box.
>>
>>any ideas?
>>
>>thanks - brenda

>Brenda,
>This one might fit if you like cheating. Normally report designer doesn't show >fields if it's a cursor but does show all variables
>
>select * from mytable into cursor myquery
>scatter memvar memo blank
>modi report myreport

>Now fields are in variables list (flexible no alias is used).
>Cetin

good idea. had not thought of that. could be the answer. but still want to try and use the fields list box. that is where my clients are use to seeing their fields.

the only way that i have even been able to see anything in the fields list box is if i add the table to the data environment. is this true? in 2.6 the currently selected table displayed in the fields list box. could i possibly add the results of my query to a table structure and add it to the data environment - programmatically? do you think this is possible?

thanks - brenda