The customer want to change the type of the primary field.However, there is no way.
This will allow lookup items to be sorted correctly if using another data type. Eg. We have a requirement to maintain a list of Levels and an amount. If whole number values are stored in the Primary field (name), records are sorted incorrectly eg.
Insted of 1,2,3,4,5,6,7,8,9,10,11,12 ect
We get 1,11,12,3,4,5, ect.
It would also be nice to have a picklist/optionset at the primary attribute