Hi there.
I have been batting my head against a wall here for days and have to post something to see if some nuggets can be mined.
I have a form with the dropdown component with the list source connected to a query. The drop down works perfectly and I can select items and then all selected list in the drop down (multiple set to true). I can then save the comma delimited list to the database.
The issue I am having is loading the dropdown with what was saved to the database. When I am not using a data source and just static items in the dopdown to select, the SelectByValues(13,34,35) works fine but is ignored when I connect the dropdown items to a data source. Using JSonObj:= SO('13') and then SelectByValue(JSonObj) works but then the number 13 is displayed as a selected item instead of the caption.
When I select an item from the dropdown after load, then the caption is displayed as it should. So then I get the original '13' above and then text in the next item selected.
Part of my issue is I cannot find any documentation on this super object idea that seems to be part working. Is there another way to construct the super object or a better way so then the dropdown has the preselected values for a user when using the dropdown items connected to a data source?
Cheers!