Joining tables in database viewer
Autor: Errol W.
Besucht 591,
Followers 1,
Geteilt 0
Is it possible to join related tables of a database in the database viewer? I am currently using two viewers to see the related tables. Is this something I need sort with SQL on the server where the base is located?
Gepostet am
Hello Errol
Joining tables in the viewer is not possible.
Maybe you could create a view-table for your purpose.
I would solve it by using a php-script, sql and html for the table. This will be the easiest I think.
You can see a simple example here : http://eksempelsite.dk/udstillinger/Emner.php
You can integrate it in X5 by using an iframe.
Example for that here : https://mogenshansen49.dk/det-gamle-testamente.html