Symptoms
The customer would like to cache data on a drop-down list that joins a SQL Table (via SmartObject associations). The peculiar thing is that it works when the "Cache the data" checkbox of the drop-down list is unchecked, but does not when the "Cache the data" checkbox is checked.
Diagnoses
Upon viewing package given I can see that the last drop down that pulls data from an associated smart object and also has cache data enabled will not populate with data when the form is run. Removing the cache data option from the drop down list data field and then running the form will allow the data to populate. Taking off the 'Show items from associated smart object' will also allow the data to populate. Having each enabled will cause the issue.
Resolution
This was identified as a bug with using both the cache the data option as well as the 'show items from an associated smartobject'. These features will work as intended when they are both individually selected. The only issue comes when using both at the same time. These options are located on the data property of the dropdown list control.
Workaround:
Do not use both options at the same time. If possible perhaps doing a sql join of the data that is supposed to be seen here instead of using the associated smart object to show values as well. This is of course only applicable if the data is coming from sql for both smartobjects.
