Meta Box

Join table

Support › MB Relationships › Join table

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • June 24, 2024 at 7:33 PM #45693
    admin@dantianhealth.com.au[email protected]
    Participant

    How do I create a join table with Metabox?
    eg I have two items herbs and formulas. A formula will have multiple herbs and herbs can be in multiple formulas (many to many). However I also need to save data specific to that relationship (eg in Forumla X, Herb Y does is 9g, Herbz Z does is 10g etc).
    Thanks

    June 24, 2024 at 10:02 PM #45695
    PeterPeter
    Moderator

    Hello,

    What do you mean by joining table with Meta Box? The relationship data is saved to a custom table, I think that it suits your requirements. Also, the relationship connection is bi-directional by default, which means you can select many formulas connected to many herbs and vice versa.

    Following the documentation https://docs.metabox.io/extensions/mb-relationships/

    June 25, 2024 at 8:46 AM #45701
    admin@dantianhealth.com.au[email protected]
    Participant

    I mean a join table that defines the relationship between two other tables and holds information about that relationship.
    Currently with relationships I can only see how to make my herbs relate to many formulas, or formulas to many herbs. I cannot see how I add information to that specific relationship such as dosage

    Join Table

    June 25, 2024 at 8:46 AM #45702
    admin@dantianhealth.com.au[email protected]
    Participant

    Join Table

    June 25, 2024 at 8:48 AM #45704
    admin@dantianhealth.com.au[email protected]
    Participant

    For example each custom post type could have information held about it as a custom field (in the image staff details/customer details). It is the information ABOUT the relationship I am trying to also capture, not just the existence of the relationship (eg in the image not just saying a staff met a customer but there was a payment with amount, date etc)

    June 26, 2024 at 10:10 PM #45728
    PeterPeter
    Moderator

    Hello,

    Currently, we don't support adding a custom field or more information about the relationship. You can create your own custom code to have a custom table that holds that information but it isn't a feature of Meta Box itself and beyond our scope of support.

    June 27, 2024 at 7:59 PM #45744
    admin@dantianhealth.com.au[email protected]
    Participant

    That's a shame, is it something on the roadmap at all?

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