Answered MIGX - Descriptive values in Column fields

This should be simple, but I'm having a brain explosion...

I have a Mixdb CMP. One of the fields has a value of 1 or 0. 1=Primary and 0=Secondary. In my Formtab definition, it is easy to replace the 1 and 0 with something descriptive by using Input Option Values of: How do I do the equivalent for the Column display?

(I've previously done this by joining to a descriptor table and substituting values, but with only two possible values this would be overkill)

I've got another instance of this now where I'm using a listbox to do in-line editing. It is simple to set up the listbox with the descriptors (in this case "Paid" or "Unpaid"), but when I make a selection I get a 0 or 1 in the column. How do I set up the column (as above) to display the text (while saving the value to the database)?

Thanks Helmut. That worked. I think if I end up with many more of these key=value pairs then I'll put them in a table so that they can be more easily maintained - but this will do fine for now.