Hi, Clayton.

I will advise you in general about the option to add another Database connection, and you can add as many Databases as you need, of course.

-

I suppose you already did this first part, since you said the connection is successfully made.

If the DB Connection Test was successful.

Once you fill out all these DB connection details, try the "Test Connection" button.

If the connection is successful, hit the "Save Changes" at the top right.

Then, our plugin is going to save this as an additional Database connection for you.

You can also select it as the "Default DB connection" at the bottom right, if needed.

-

Now, when you go to Create a New Table in our plugin, it will first ask you which Database you will use,

then it will move to the next step, such as what kind of table you need, etc.

You will see the "Connection" selection dropdown during Table Creation.

-

After you choose this Database, then you can either manually write a custom SQL Query to pull the data from tables you need, or you can try our SQL Query Constructor Helper Tool.

-

Here you can see more details about our MySQL query-based tables.

Please note: Using this plugin feature requires at least a basic knowledge of SQL. It is assumed that you can create the table in some MySQL data manager (e.g., PHPMyAdmin, MySQL Workbench), and prepare a SQL query that will return the data you need. 

A good way to achieve this can be experimenting using our WPDB SQL Query Constructor tool.

- Please note: this tool is not an ultimate query generator. It simply constructs a suggestion of a query. We are constantly working to improve it, but SQL is such a complicated and flexible language that full automation for constructing queries is next to impossible. 

Consequently, the more complicated the query, the higher is the probability that it will not return exactly what you need. So, you will often need to play around with the resulting query.

Please be advised that writing custom SQL Queries or debugging Queries does not fall under what our support covers, but we can help with some basic troubleshooting, depending on how complex your Query is.

You can check out this official page of WP codex,  for help with writing custom Queries.

-

And as  mentioned before, we also have that refund period, so you will be able to fully try out everything you need and we will be here to provide support.

If the plugin does not suit the use-case, you can also get a refund.

Let us know if that helps.

-

2. In regards to editing tables on front-end WP Page and having it update the source table from the Database,

this is the default behaviour.

You can choose either SQL Query Based table if you need to manually make the SQL Query to pull the data,

or try our SQL Query Constructor helper, as said above;

then activate front-end editing, in the Editing settings of this table,

and front-end users can edit it, it will store the changes to the source DB table.

-

Let me know if that helps.