We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

Okay
  Public Ticket #2913810
Foreign Keys
Closed

Comments

  • Michael started the conversation
    November 10, 2021 at 7:48pm

    Hi,

    1 -  have an SQL table that holds a list of books.  The index is the ISBN. (the shared foreign key)

    2 - I have another SQL table that holds the details of the book, that also has the ISBN is the foreign key.

    When the user searches the Books, I want a table of books (1).  However when the user clicks on the more. button (I have Master Detail Tables) how do I get the page to show the details. from the. book details (2) rather than then list of books? (1)

    I have seen the material in relation to foreign keys but would like an explanation of how I would get the MDT to read the second database and not the first.

    Thanks

    M

  •  2,576
    Aleksandar replied
    November 15, 2021 at 10:04am

    Hello Michael

    The 1st table should be used as the source, so the second table pulls the data from the first table based on an ID.

    For example, the 1st table has an ID column that stores unique IDs for books, and that column should be used as the "Store value" when you're configuring the Foreign Key in the 2nd table. The 2nd column in the 1st table should be the Title column, where titles of the books will be added. This column should be added as the "Display value" in the 2nd table.

    The column in the 2nd table needs to be an integer column, so the ID from the 1st table is recognized in the 2nd table. Also, the column names from these two tables should not be the same, otherwise, it may not work correctly.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables