Show text instead of number
Posted: Sat Feb 27, 2016 11:29 am
Hi, forgive my english is'n good. I have a Grid subform and a column has only 4 posible values disabled to edition. I want to show it in Display mode like text and i dont want to create a table only for this, in Display Tab i wrote "SELECT des,cod FROM ( SELECT '1' AS cod, 'ALTA' AS des UNION SELECT '2' AS cod, 'BAJA' AS des UNION SELECT '4' AS cod, 'MODIFICADO' AS des UNION SELECT '3' AS cod, 'DISPONIBLE' AS des) AS T1" and i dont know what put in WHERE clause because the field is neither index nor primary key. Thanks.