I am currently trying to Import some Products Data into my file. For two fields I later want the user to choose from a pre-defined value list, which I store in a separate table. The Popup-Menus are working fine, but I have a problem now with importing my old data! I used numbers to uniquely identify each entry in the value list, but only show the contents of the actual name field in the popup! I checked "override data formatting with value list" so the field shows the name of the value list entry but in reality only stores the related number.
The Excel file i want to import from only has the names in it.
I could try something like:
If (Get (ActiveFieldContents) = "Production")
Set Field [PRODUCTS::Type = 3]
Else If ( (Get (ActiveFieldContents) = "Trading Goods")
Set Field [PRODUCTS::Type = 5]
But isn't there a way i can make the script check what is in my imported field and then match it with the related number from the value list table? Hope I could describe the problem, further questions let me know!
Thanks for any comment!