I’m trying to make a dashboard with a combo box but the only way I’ve found to populate it is to have another grid somewhere on the page that calls an ERP service (can be any doesn’t need to be related to the combo service being called) in it’s provider model.
This is my dashboard layout
The Department combo box is in a panel card (not Panel Card Grid), these are my inputs for the combo box
My two grids in Successful and Failed are binded to views that will be populated by a function upon clicking a button
These are the inputs on my grid at the bottom of the dashboard
This is my view
This also only works if the bottom grid is visible and not hidden. It doesn’t matter which service or even BAQ I use, it doesn’t have to be JCDept. My guess is that when the grid is displayed and a service/BAQ provided in the provider model then it establishes connection to the server so that my JCDeptCombo can also connect, otherwise it doesn’t get established. It might also be on a per view basis because this only works if I bind the service in the provider model and the combo box to the same view.
I thought it might be that my view doesn’t have access to the JCDept tables, but even if I make a view on JCDept (either manually or through wizard) this is still the only way I can get this combo box to populate.
Maybe I’m missing something or doing something wrong because it feels like there should be a better, easier way to do this. It’s possible to work around it but I don’t really want to have tables on my dashboard that are only there so that this combo box works. Any pointers would be amazing 
