Echoing what I said to Mark at the end of this response:
https://community.wappler.io/t/wappler-project-lost-connection-to-database/65283/9?u=cheese
I'd like to suggest that Wappler has a single area to manage Database Connections for each Target rather than its current implementation. ie, in the main menu on the left, and then in Server Connect Globals, and then again in the Project Settings Target dialogue. Also what does the Advanced tab actually do in the Database Manager?
It displays some data normally hidden to the user, not much but a few subtle differences
Here is an example using a table with sub table.
Basic Mode:
Advanced:
Note how the reference field of the table/subtable link is only exposed in the advanced tab.
If i recall correctly it also used to expose some additional field types but this does not seem to be the case now.
I seem to recall the Wappler team indicated that was on the drawing board for Wappler 7 but it never materialised.