>i have used browse windows before to show the fields in a table ... as is. now i want to show 3 fields a the table ... as is ... but i want to show the description of the 4th field, not the code that is the actualy field value. i have a two dimensional array that has the description and the code. but how do i use that in a browse window?
>
>thanks
>
>brenda
Brenda,
I agree with Ken that if the description is in a table with an index on the code it will be a lot easier because you can just issue a SET RELATION command to keep the files in sync and reference the table as follows:
BROWSE FIELDS field1, field2, field3, lookuptable.descr
But if you have to use the array, you could set up a UDF that scans the array and returns the description. In the browse field list create an expression that calls the UDF:
BROWSE FIELDS field1, field2, field3, tmp=FINDDESCR(field4)
Cathy