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.
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.
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
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
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
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
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
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
This topic is locked and no more replies can be posted.
