For Category(the second) one, some questions.
Suggestion 1: Add a Refresh(Table1) in your OnVisible of the Form to try to force it to reload.
Suggestion 2: Add a Gallery to a Screen or a DataTable, and bind Table one to that. Just to see if loads any of the data.
Question 1: These look like Classic Dropdowns, is that correct?
1. Can you click the control (like you have), then on the right-hand side, you should see the properties and verify that the Value (dropdown) has a Column Selected, and that your Items is set too here. If not please select them.
Also, did you enable the Depends on? You don't have too, just checking if you did.
These checks are to make sure that (if the refresh) doesn't work, we can isolate which part is
2. If you run the app (after checking all of #1s things) and you have refreshed in OnVisible etc, does the Drodown open up and is long.. as if it has data, but you cannot see it? And if you click any of the lines.. it actually acts like you picked something and closes?
3. Also for your cascading. Leverage this
Dropdown2.SelectedText.Value
Where change Dropdown2 to be your Category filter in your Type Items filter
If all else fails
It looks like you have done everything. So, it's possible you just need to save, CTRL F5 to refresh to have it take effect. That or you can go to the Data Tab, click your Table1 (right click) and choose refresh.
Then if still nothing, Data Tab, click your Table1 (right click) and choose edit data. See if it actually opens the excel properly.
The last final thing is if its locked by something else this can happen so make sure its not. And note: if you delete the file ever and recreate it (even with the same name) it will break your app.
Let me know and we can continue trying to figure it out
or if any of these work, I'd be grateful if you Marked it as such.
Thanks!!
