I need to create a fairly simple database within WP with three tables, with hierarchical relationships descending top one has many related second-tier, and second tier has many third tier, e.g. one practice has many practitioners, one practitioner has many clients.
I can't find any reference to creating relationships, it appears that table all stand alone.
We have our own implementation of table relations and you can find more information about it in our - Documentation. Basically you need to have id column from one table in another and then plugin will allow you to show data from different column instead of ids. For Example if you have id column and name column in first table and column with ids from first table in second you can show names instead of id in second one.
For testing purpose we have sandbox website where you can see and test all plugin functionalities
I need to create a fairly simple database within WP with three tables, with hierarchical relationships descending top one has many related second-tier, and second tier has many third tier, e.g. one practice has many practitioners, one practitioner has many clients.
I can't find any reference to creating relationships, it appears that table all stand alone.
Hi David,
Thank you for your inquire.
We have our own implementation of table relations and you can find more information about it in our - Documentation. Basically you need to have id column from one table in another and then plugin will allow you to show data from different column instead of ids. For Example if you have id column and name column in first table and column with ids from first table in second you can show names instead of id in second one.
For testing purpose we have sandbox website where you can see and test all plugin functionalities
sandbox.wpdatatables.com
username: demo
password: demo