Problem importing data into hierarchy
I am having a problem importing data into an already established hierarchy.
My hierarchy table Z_Manufacturer has 4 fields:
Name [Text, Display Field 1]
Code [Integer, Display Field 2]
We have 2 display fields setup because we want to see both the name and code in Data Manager. We want the name to be displayed first.
The problem I am having is that when we try to import a file of type XML schema into this table, I can successfully map the Code, Phone, and URL fields, but when I try to map the Name field, in the Destination Values portion, it lists Z_Manufacturer in hierarchy format, but when I expand it, it displays the 5 digit number instead of the name. Why is it not displaying the name???
I tried switching the order of the display fields, so that the Code is DF1 and the Name is DF2, and then the Names are displayed in the Destination Values portion for Name, but we do not want the number displayed first in Data Manager.