in my add/edit form I use lookup tables to select values. E.a. there are an integer field 'inquiry' and a vchar field 'inq_decription'. Values for 'inquiry' vary between e.g. 1, 79, 52 e.a., the corresponding description 'inq_decription' may be 'monitor' e.a.
In visual editor 'Edit as...' I use 'inquiry' as Link field and concat(inquiry,', ',inq_despription) as Display field.
The Lookup Wizard Test shows the correct informations in the drop down selection like '1, single; 79, multi e.a. and the right coresponding values 1, 79,...
I use this method to give users some hints about the meaning of these numeric values - which o.t.o.h. alone are needed for (CSV)export.
Checking the table with Navicat shows the right values stored in the main table, alas when exporting records the contents of the Display field are exported rather than the values...
Is this done intentionally, is it a bug or is it plain lacking 'vista' or knowledge of a novice?
Thanks for any enlightenment...
BTW: Display field is also shown in record view mode rather than the values. This doesn't really matter, but for export I only have to user the values