I am trying to figure out how to create parent child tables. For example an Order table (header or parent) and then Order Items table (child to Order table with multiple rows linking to the parent).
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
1. When it comes to creating tables with a Parent-child relation between them, it depends what you wish to achieve exactly.
If you wish to try our "Foreign Key Column" to create a relation in order to call data in a column from another table, this feature only provides a 1 to 1 relation, it can not be a "1 to many" relation.
You will find our example as an SQL Table which is 'orders', it is calling the data from multiple other SQL Tables like 'customers', 'employees', etc.
Let me know if that can achieve what you need, or if you need something different?
2. Or, if you wish to join data from multiple Tables, you can do a custom SQL Query based Table and use an SQL JOIN or UNION function.
Please note: Using this plugin feature requires at least a basic knowledge of SQL. It is assumed that you can create the table in some MySQL data manager (e.g., PHPMyAdmin, MySQL Workbench), and prepare a SQL query that will return the data you need. If you do not know how to use MySQL, refer to the “Create a MySQL-query-based table by generating a query to MySQL database” section. It will explain how to create complete tables or MySQL queries without this basic knowledge. Please be advised that preparing MySQL queries for you is not included in the plugin support.
3. There is a new possibility, which is almost finished, with our Master-Details add-on.
Our developers will launch a new version of our Master-Details add on 2.0, which has new functionalities.
You will be able to create a relation which can be used as "more Details" on a custom template Page or Post, and you can choose from your available wpDataTables which one is the 'parent' and which one is the 'child', etc.
We are just still not finished with this new Documentation which will explain how all this works and all the possible options you will have, and the new Master-Details version 2.0 add-on is still not released.
We are planning to finish all this in the next couple of days, but our QA Team and our Documentation Team are still checking everything before the official release.
Can you please just provide a bit more details as an example, and let me know if something from the details we pointed out could work for your use-case?
If you can add any screenshots or a Video as a more detailed example of your goal, and we will check if that is possible.
If a Video gets too large, you can upload it anywhere like weTransfer and send a download link.
If it shows any sensitive data, please just mark the reply as PRIVATE, then only we can see it.
I am trying to figure out how to create parent child tables. For example an Order table (header or parent) and then Order Items table (child to Order table with multiple rows linking to the parent).
I couldn't find anything in the documentation.
Thanks
Beverly
Hi Beverly,
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
1. When it comes to creating tables with a Parent-child relation between them, it depends what you wish to achieve exactly.
If you wish to try our "Foreign Key Column" to create a relation in order to call data in a column from another table, this feature only provides a 1 to 1 relation, it can not be a "1 to many" relation.
Please check more about this feature here.
You will find our example as an SQL Table which is 'orders', it is calling the data from multiple other SQL Tables like 'customers', 'employees', etc.
Let me know if that can achieve what you need, or if you need something different?
2. Or, if you wish to join data from multiple Tables, you can do a custom SQL Query based Table and use an SQL JOIN or UNION function.
Please note: Using this plugin feature requires at least a basic knowledge of SQL. It is assumed that you can create the table in some MySQL data manager (e.g., PHPMyAdmin, MySQL Workbench), and prepare a SQL query that will return the data you need. If you do not know how to use MySQL, refer to the “Create a MySQL-query-based table by generating a query to MySQL database” section. It will explain how to create complete tables or MySQL queries without this basic knowledge. Please be advised that preparing MySQL queries for you is not included in the plugin support.
3. There is a new possibility, which is almost finished, with our Master-Details add-on.
Our developers will launch a new version of our Master-Details add on 2.0, which has new functionalities.
You will be able to create a relation which can be used as "more Details" on a custom template Page or Post, and you can choose from your available wpDataTables which one is the 'parent' and which one is the 'child', etc.
We are just still not finished with this new Documentation which will explain how all this works and all the possible options you will have, and the new Master-Details version 2.0 add-on is still not released.
We are planning to finish all this in the next couple of days, but our QA Team and our Documentation Team are still checking everything before the official release.
Can you please just provide a bit more details as an example, and let me know if something from the details we pointed out could work for your use-case?
If you can add any screenshots or a Video as a more detailed example of your goal, and we will check if that is possible.
If a Video gets too large, you can upload it anywhere like weTransfer and send a download link.
If it shows any sensitive data, please just mark the reply as PRIVATE, then only we can see it.
Thank you.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables