Displaying Master and Child tables

Alex_Kite 15 Jan, 2015
Good afternoon,

Please give some guidelines to create the form based on 2 tables - "Customers" and "Orders".
The form should display all info about the selected customer along with the sub-table displaying the orders of this client, and should provide basic buttons to navigate between clients, search them and create new ones (as I tried to lay out on enclosed jpeg).

My preferred desktop application for this kind of tasks was MS Access, but now I'm searching for appropriate "cloud" solution.
I'm quite new to Joomla, but have many years of C++ and VBA programming background and now getting basic experience in PHP and CSS.
GreyHead 16 Jan, 2015
Hi Alex_Kite,

I'm not quite sure what your question is?

You could do this using ChronoConenctivity for the listing and ChronoForms for the add/edit forms. Check the CCv5 FAQs to get an idea of where to start.

Bob
Alex_Kite 16 Jan, 2015
Hi Bob,
Thank you for reply.
I've already studied FAQs but unfortunately didn't find the answer.

To clarify my question: I want to, let's say, insert a subform in a form.
The main form should display one record from "Clients" table, while a nested form displays
all orders Where orders.client_id = clients.client_id.

Best regards,

Alex
GreyHead 16 Jan, 2015
Answer
1 Likes
Hi Alex_Kite,

Use a DB Read action to load the child table data and PHP in a Custom Code element in the Designer to show the table. The PHP just to loop through the data and display the rows.

Bob
Alex_Kite 16 Jan, 2015
Hi Bob,

Thank you very much for you answer!

BR
Alex
This topic is locked and no more replies can be posted.