A have a DB that has numerous lookup fields to populate data; when i export the data it will always export the value of the lookup/display filed that is selected. I would like for my export for one of those to export the actual value stored in the Table and not the lookup field display value. Is there an 'easy' way to do this?
IE - A lookup field for a CarMake is defined as a lookup value and displays both make and model in the dropdown lookup list, but stores the Make in the field when saved. When using the export function I want it to only export the Make and not the Make - Model as displayed in the lookup display definition.
Thanks..Jon
