I'm trying to merge two fields from one database into one field in another database.
I've sort of made it work by selecting both fields in Specify Fields for Value List. But when I go to browse mode both fields appear as they should but when I select a record from the drop down list only the first field appears and not the second.
ie: Job Number and Description appear in the drop down list but only Job Number appears once selected.
Your help would be much appreciated.