I have a combo box where user can pick a value from a lookup table, and I'm baffled why I can't get the format right.
It worked fine until I uploaded my tables to SharePoint lists, that's why I'm posting this here.
The lookup table has primary key TypePK, (autonumber, as seems to be required by SharePoint). Other fields are TypeCode (double, but all entries are integers) and Description (string).
The main table has a field Type (long integer) which links to TypePK.
The combo box looks up TypePK in the lookup table, but shows TypeCode on the form.
Why is TypeCode showing two decimal places in the combo box, i.e. 1.00 instead of 1?
Entries show as integers on the row source query.
I've changed the format of the combo box to General Number and anything else I could think of, with Decimal Places 0.
I realised that double is not the appropriate data type, so I went to my SharePoint list to change it. Even changing it to text would work. But SharePoint won't let me, it says I can't change the column type because it is 'being indexed'.
I tried to delete the index, but it goes to a page saying 'the index is being deleted' and stays there forever.
I don't know much (at all) about SharePoint. If I deleted the list and made a new one with a sensible data type for TypeCode, would I still be able to have all the referential integrity I went to so much trouble to preserve in my current lists?
A thousand thanks for any tips that might help.