WP Data Access
  • Download
  • Support
  • Features
  • Pricing
  • Documentation
Select Page
Popular Search formimportqueryshortcodesql

WP Data Access

  • Getting started
  • Installation
  • What’s new?
  • Patches
  • Known limitations
  • FAQ

Data Tables

  • Getting Started
  • Creating and publishing
  • Responsive data tables
  • SEO friendly data tables
  • Adding hyperlinks
  • Extension Manager
  • Style Manager
  • Language settings
  • Styling
    • Style Manager
    • Premium styling
    • Global styling
    • Code Manager Styling
    • Manual styling
    • Styling issues
  • Filters
    • Static filters
    • Interactive filters
      • URL parameters
      • Search Panes
      • Search Builder
      • Search form
      • Advanced search
      • Geolocation search
  • Export & other buttons
    • Export to PDF, CSV, Excel, SQL
    • Print & copy buttons
    • Column selection buttons
    • Custom buttons
  • Advanced features
    • Advanced settings
    • Large tables & performance
    • Progressively SHOW MORE
    • Custom queries
    • Custom Post Types
    • Row grouping
    • Responsive master-detail
    • Master-detail tables
    • Non admin user access
  • Demos & tutorials
    • Demos
    • Tutorials

Data Apps

  • Data Projects
  • Projects and templates
  • Supported Data Types
  • One-To-Many relationships
  • Many-To-Many relationships
  • Registration page
  • Manage table options
  • Shortcode usage
  • Project Templates
    • Project Templates
    • Creating templates
    • Table Settings
    • Relationships
    • List Table
    • Data Entry
    • Reconcile
  • Data Forms
    • Data Forms
    • Overview
    • Project Demo
    • Page Demo
  • Advanced features
    • Adding filters
    • Custom validation
    • Add less/more button
    • User roles
    • Managing roles and users
    • Advanced table options
    • Advanced lookups
    • Front-end toolbar
    • Transfer to other WP site
  • Demos & tutorials
    • Demos
    • Tutorials

Data Explorer

  • Getting started
  • Navigation
  • Explore tables & views
  • Manage tables & views
  • Naming conventions
  • Manage Actions
    • Actions
  • Manage Settings
    • Settings
    • Table Settings
    • Column Settings
    • Search Settings
    • Geolocation Settings
    • Dynamic Hyperlinks
    • Dashboard Menus
  • Data Management
    • Import CSV & SQL files
    • Run SQL script files
    • Data Backup
  • Problems & solutions
    • InnoDB #rows estimation
    • Import file too large
    • Transfer to other WP DB

Remote Databases

  • MySQL | MariaDB
  • Other DBMS
    • Heterogeneous Connections
    • Using ODBC | JDBC
    • Connect to SQL Server
  • Premium Data Services
    • Remote wizard
    • START HERE
    • Errors and messages
    • Limitations
    • Tutorials
    • Remote Databases
      • Remote databases
      • SQL Server
      • PostgreSQL
      • Oracle
      • MariaDB | MySQL
    • Remote Data Files
      • Remote data files
      • CSV files
      • JSON files
      • MS Access
      • XML files
      • Public URL
      • Synchronization
    • Advanced features
      • Performance
      • Indexes

SQL

  • Getting Started
  • Tutorials
  • Visual Query Builder
  • Writing queries
  • Data exchange
  • Stored procedures
  • Database triggers
  • Scheduled queries

Business Intelligence

  • Getting started
  • Dashboards
  • Sharing dashboards
  • Dashboards Widgets
    • Dashboard Widgets
    • Publication Widget
    • Project Widget
    • Chart Widget
    • Custom Code Widget
    • Database Widget
    • Sharing Widgets

Table Design

  • Getting started
  • Introduction
  • Basic mode

Plugin Settings

  • Getting started
  • Plugin
  • Back-end
  • Front-end
  • Dashboard
  • Data Forms
  • Data Tables
  • Data Backup
  • Uninstall
  • Manage Repository
  • Manage Roles
  • System Info

Code

  • Shortcodes
    • Overview
    • wpdataaccess
    • wpdadataproject
    • wpdadataforms
    • wpdadiehard
    • wpdageomap
    • wpdawidget
  • Plugin Variables
    • WordPress user ID in SQL
    • Environment variables
  • Hooks & filters
    • Overview
    • Hooks
      • Overview
      • wpda_add_search_actions
      • wpda_add_search_filter
      • wpda_before_list_table
      • wpda_after_list_table
      • wpda_wpdataaccess_prepare
    • Filters
      • Overview
      • wpda_column_default
      • wpda_before_simple_form
      • wpda_after_simple_form
      • wpda_construct_where_clause
  • API
    • WP Data Access API
    • Remote database access
    • CRUD Example
    • Extensions
      • Alternative search algorithm
      • Alternative buttons extension
  • Code Manager
    • Overview
    • Write code
    • Share(d) code

Many-To-Many relationships

IMPORTANT Please notice that tab Manage Table Options is no longer available. Table Options was renamed to Project Templates and can now be accessed directly from the plugin menu.

Share This Article :
  • Facebook
  • Twitter
  • LinkedIn
  • Pinterest
Still stuck? How can we help?

How can we help?

Updated on 2023-01-11
One-To-Many relationshipsRegistration page

7 Comments

  1. Zack
    Zack on 2020-05-17 at 5:36 pm

    I’m close, but when I test the table I can delete items from the class table, but I cannot add.

    ERROR: Not all rows have been added

    Reply
  2. Peter Schulz
    Peter Schulz on 2020-05-17 at 8:56 pm

    Hi Zack,

    Can you send me some screenshots? Please use the contactform if you prefer to send them in private.

    Thanks,
    Peter

    Reply
  3. Jeffrey
    Jeffrey on 2020-10-26 at 4:15 pm

    I am also getting this same error, was there a solution to it?

    Reply
    • Peter Schulz
      Peter Schulz on 2020-10-27 at 7:16 am

      Can you send me your table options the related tables Jeffrey? Please use the contactform to send it in private.

      Thanks,
      Peter

      Reply
  4. carl
    carl on 2021-03-16 at 8:22 pm

    I am wanting 3 tables, Table A the parent of Table B and Table B the parent of Table C. It looks like I cant just have a relationship (1:n) on Table A ==> Table B and Table B ==> Table C. This only gives me access to Table A and B.

    I tried adding a relationship Table A ==> Table C, and that gives me access to tabs for Table B and Table C but it wont let you link Table B to Table C.

    What am I doing wrong. I have only one template for each table.

    Reply
    • Peter Schulz
      Peter Schulz on 2021-03-17 at 11:04 am

      Hi Carl,

      The plugin supports only one hierarchy level on a page. If you want to manage multiple levels on one page, you can use dynamic hyperlinks to jump between different levels. Multi level supports is planned for Data Forms (not yet available). Not for the back-end and shortcode wpdadiehard.

      Does this answer your question?
      Peter

      Reply
  5. H Sautter
    H Sautter on 2022-04-02 at 4:28 am

    When I attempt to “Add New” child row in a many to many relationship, I get an insert error.
    The child row is created but the links between the two tables are not.
    Add existing does not get an error.
    See the PHP log entry below:

    family ==> member ==> details

    Table family has the parent record
    Table details has the child record
    the row fails to insert into table member

    The database is named directory…. not wp_testsite_db

    [02-Apr-2022 03:55:51 UTC] WordPress database error Table ‘wp_testsite_db.member’ doesn’t exist for query
    SHOW FULL COLUMNS FROM `member`
    made by do_action(‘directory_page_wpda_wpdp_1_1’), WP_Hook->do_action, WP_Hook->apply_filters, WPDataProjects\WPDP->manage_project_page, WPDataProjects\Parent_Child\WPDP_Parent_List_View->show, WPDataProjects\Parent_Child\WPDP_Parent_List_View-

    How can I fix this?

    Reply

Submit a Comment Cancel reply

Your email address will not be published. Required fields are marked *

Links

Blogs
Tutorials
Demos

Socials

LinkedIn
Twitter

Get in touch

Premium support
Free support forum
Contact us

Resources

WordPress plugin directory
YouTube tutorials

Passionate Programmers B.V. © 2017 - 2023 All rights reserved