Hello All
Is there a way to display a value in the column of a grid based on a case or an if..endif structure? For example, in my application, I am displaying the aged transaction history for customers. In the table, there is a field called "type" that describes the type of transaction in the A/R transaction file, "1" = Invoice, "2" = Adjustment, "8" = Cash Receipt, etc.. The data type is numeric. In the grid that displays the table, I would like to display "IN" if the type = 1, "CA" if the type = 8 etc. I do not know why the original designers of the application made this field numeric, I am converting this application from Clipper and would reduce my headaches a lot if I didn't have to mess too much with the tables. So is there a way to parse the value of the given field in the table and display the appropriate 2 character message. All suggestions appreciated.


Regards,
Carmen