I have a Class called Lifecycle_OrderNos which contains information about placed orders for assets - order no., supplier, date of order. This has a domain set up with the CI_Workstations Class which contains Workstation CI asset information. However, I have a slight problem. I don't strictly speaking need the Code and Description fields, but I initially set the Code to Inactive and Description to the Order Number. This works great adding a CI_Workstation card manually; drop down list is populated, can choose one. However, when I want to import a load of new Workstations from a .csv file the Import wizard doesn't look at the Description field to match the Referenced field for the Workstation Order Number, but at the Code field. If I define the code field to be the order number and don't use the Description field, the Referenced field then appears empty in the Card view of the Workstation CI.
The only way I've found to resolve this is to have the Order Number duplicated in both the Code and the Description fields, so that the .csv Workstation import can work and the order number be visible on the Workstation card. What I'd like to be able to do is customise either:
1. The field of the Referenced card that is displayed in the Referring card (i.e. which field of Lifecycle_OrderNumber is displayed on a card in CI_Workstations when there's a 1:N relationship between the two)
2. The field the .csv import uses to match Referenced fields in the target class
Or, ideally, both.
Is there any way to do this?