It is common during the testing or troubleshooting of data connections to make frequent changes to the data source or connections settings. Some users might find that although the results shown in the "Edit ProForma Data Connections" screen appear correct, the data is different when it is accessed on a ProForma form.
Disable Caching to Ensure All Data Updates
Make sure the data connection is constantly updated during testing by setting the Cache Results value to Do not cache. This will ensure that old data does not remain in memory, and that all changes to the data source or the data connection settings are applied when the form accesses that data.
Revert to Desired Caching Setting
Once testing or troubleshooting is complete, make sure to revert back to your desired caching settings if you want caching to remain enabled during usage.