I am new to Focus, so bear with me. I am using sql server as data source. I have a table with code/descrip fields. I need to display the descrip and not the code. Not sure how to accomplish this. Create a hold file to use for a DECODE? Or is there something in the LOOKUP function? Thanks in advance.

I'm going to assume this is a report, so:
1) Join the description table to the source table.
2) Use the descr field instead of code in the final report.

e.g.
JOIN CODE IN Source TO CODE IN Description AS J1
TABLE FILE Source
SUM ....
BY CODE NOPRINT
BY DESCRIPTION
END

Hope this helps.

worked great!! Thanks