Hello,nowhere I found some information about using Database Table relationsI have the following two tables in the mySQL Database:tableCar:ID Typ User-----------------------1 Mercedes 22 Audi 1 3 Honda 2tableCarUser:ID Name-----------------------1 Martin2 Bill3 BoboI would like to create the following table in my dasboard:Car User------------------------Mercedes BillAudi MartinHonda Bill
How can this be done?
Is it possible to have relations between tables or do I have to create a DB View for this?Thanx, best Regards, Martin
Hi Martin,
Thank you for being our customer!
In the current version yes, you need to create a DB View. In the next version you will be able to do a join at ReportPlus, though this may not be the best in terms of performance for mySQL.
Does this answer your question?
Please don't hesitate posting back should you need more help.
Take care,
Hello,
thanx for the reply. You answered all my questions. I am pleased to get the new Version ;-)
Best regards, Martin
To create database tables for these models, follow the general procedure for ... Follow the basic procedure in Attaching models to data sources