As previously announced via banners and our newsletters, support is no longer available through this platform.

For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.

You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.

Paid customers: Please log in to your store account for support.

Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com

Okay
  Public Ticket #1636615
Relationships
Closed

Comments

  • David Livingstone started the conversation

    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.

  • [deleted] replied

    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