Here’s what I am thinking:
Just after adding a dataset and connecting your button, have the ability to connect two databases simultaneously.
After connecting your buttons to several databases simply pick and choose the correct setting for you user inputs.
If you have a form asking a bunch of questions, connect the different inputs to which ever databases you would like to submit to.
If your form asks for: name, email address, contact number, product name, & for a product description. You may want the name, email address, & contact number to be added to a ‘Client’ database. Then for all of the input fields to be added to a ‘Product’ database. All of which is done via the one submit button.
This would require the ability to also add two datasets when connecting a user input.
Of course, there’s always the ability to add a two part submission form, however, if you require the same information in two databases you have to repeat certain user inputs which can be unprofessional.
Thank you for anybody who has taken their time to read this.