Hello,
I am adding a number of integer UETs to the Item table that need to be edited through combo boxes. The list source of combo boxes are new tables that have been added to the IDO and simply contain an ID (integer) and description. I would like for the combo boxes to show just the description, and because some lists could be more than 100 items long, sortable. The problem I am running into is that while I can specify the ID and description as properties of the List Source, I can only specify the display property (description) and not the value property (ID). In C# we can specify both ValueMember and DisplayMember, but I don't see that option here.
A possible workaround would be to have the ID bound to a hidden text box and then leverage the events and form script to programmatically select the appropriate item in the combo box by looping through the combo box items and finding the ID match. However, I’m not sure if the combo box can be referenced in this way.
I thought I would see if anyone has found a solution to this before I reach out to Professional Services.
Thank You!