Joining tables in database viewer 
Автор: Errol W.
Просмотрено 587,
Подписчики 1,
Размещенный 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?
Размещено
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