My problem is this...
I have a Table0 (parent) and table1, table2, table3.... table15 (child tables) all from 1 to 15 ar related to Table0. In Table0 I have a PK (ClientID - set as UUID) and the rest have FK(ClientID).
I want to generate a report that shows clients name from Table0 and ALL records from the related tables. Problem is if I use list view and put the client field in the header and all the related fields from the related tables in the body section I only get the one record per line. I my case Table1 could have 5 records, Table 3 could have 2 records related to that clientID. How can I build the report to show all records from the related tables for one specific client.
Also be exportable to excel and work with webdirect (.tab since excel is not supported) because the reports will be generated by the user and user access is via browser.