mySQL Relational Database Question

[Dirk]

Hi,

Wysiwyg Web Builder is a powerfull tool and offers top possibilities.

I worked already with the Database tools MySQL Connector and MySQL CRUD. and also with forms and it works very good !

Now I want to make relations between tables.
I dropped two MySQL Connectors inside a page, every Connection with a different table of a common Database.
But only one of the connectors give a result to the adressed objects. (I adressed different objects in the page , multiple editorboxes )

Is there a possibility to mix Data from different tables in a page or form ?
I want to sent the mixed results to a different table.

for example:

I want to look for an article in the articles-table and then "add" the relating supplier from the supplier table and add the quantity and generate an order to him per email. The order should be written in an order-table, with date and time and the generating employee stamp.

Is there any possibility without big Java or PHP code ? Just with a helpful webbuilder extension ?

Thanks in advance !
Best regards from Germany

Dirk

[Pablo]

I'm sorry, I do not have a standard solution for this. This requires a custom script.
Unfortunately, not much users buy my MySQL extensions. So, apparently the average WWB user is not interested in database related functionality.

[Dirk]

Hi Pablo,

anyway, thank you for your quick response.
Dirk

[onlye]

Hey Dirk,

I am working on a new project that I may want to pull info from multiple tables (join) in the same database select a few and then display resulting rows. Let me know how your project goes and your solution.

Thanks!

[bkjohns]

I'm sorry, I do not have a standard solution for this. This requires a custom script.
Unfortunately, not much users buy my MySQL extensions. So, apparently the average WWB user is not interested in database related functionality.

Pablo, would the Datatables extension work with a relational MSAccess database that was the final table generated from queries made within Access? I know it is a local file only for Access, but the op didn't seem to indicate it had to be server based.

[Pablo]

The extension was designed to work with one dataset.
However, in the latest update you can create custom SQL query to get the result from different tables.