Hi,
In the Lookup Wizard, when the 'List of Values' is selected, it does not appear possible to store one value in the database and display another on the page e.g. Store Y/N and display Yes/No. The only way around this appears to be to store Yes/No in the database, or to have a Yes/No Table and use the Lookup Table feature, which may make the SQL much more complex. I don't really want lots of extra Database Tables storing Yes/No, True/False, Accepted/Rejected etc, storing values which are never going to change. This is a regular feature of most other programs.
The above also applies to Checkbox and Radio Buttons. It does not seem possible to define the values for a Checkbox, and the values for a RadioButton appear to be the same as Lookup Wizard - List of Values.
On Edit/Add Pages it is sometimes useful to make a field readonly but still display it. However if that field is a lookup, only the code value will be displayed, as you can either choose Readonly or Lookup Wizard. Also, if the field is a date/time, the readonly field is displayed as a date/time and there is no choice of formatting.
It would be great if the Lookup Wizard can be made more flexible, or does anyone have some workarounds?
Gordon
