Meta Box

Custom Tables with Many to Many Relationship

Support › MB Custom Table › Custom Tables with Many to Many RelationshipResolved

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • June 30, 2020 at 1:33 PM #20555
    Asad Ur RehmanAsad Ur Rehman
    Participant

    Hi,

    I want to make a custom plugin and I would like to know how I could create Custom Tables that have Many-to-Many relationship.

    i.e.
    Quizs many-to-many Questions

    Br, John

    June 30, 2020 at 3:29 PM #20556
    Long NguyenLong Nguyen
    Moderator

    Hi John,

    A basic relationship is the many-to-many type and the relationship data is stored in a different table mb_relationships. For more information, please follow the documentation.

    June 30, 2020 at 4:22 PM #20557
    Asad Ur RehmanAsad Ur Rehman
    Participant

    Hi!

    And this can be used for underlying functionality also right? I mean not only to use it in Admin area. I just want to have Custom Tables that have relationship many-to-many so I can do inner joins in my queries.
    i.e.
    https://share.getcloudapp.com/eDu154Kl

    Br,
    John

    June 30, 2020 at 11:06 PM #20561
    Long NguyenLong Nguyen
    Moderator

    Hi John,

    I'm following the same question in a topic from Facebook Group. The answer, in short, is impossible. The relationship only saves the data in the table mb_relationships. It helps you to connect posts, terms, and users while the main purpose of the extension Custom Table is to help you to save custom fields’ values to the custom table instead of the default WordPress meta table.

  • Author
    Posts
Viewing 4 posts - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.