Hey there, Awesome Customers!

Just a heads up: We'll be taking a breather to celebrate International Workers' Day (May 1st and 2nd - Wednesday and Thursday) and Orthodox Easter from Good Friday (May 3rd) through Easter Monday (May 6th). So, from May 1st to May 6th, our team will be off enjoying some well-deserved downtime.

During this time, our customer support will be running on a smaller crew, but don't worry! We'll still be around to help with any urgent matters, though it might take us a bit longer than usual to get back to you.

We'll be back in action at full throttle on May 7th (Tuesday), ready to tackle your questions and requests with gusto!

In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find loads of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel). These gems might just have the answers you're looking for while we're kicking back.

Thanks a bunch for your understanding and support!

Catch you on the flip side!

Warm regards,

TMS

Okay
  Public Ticket #2208323
Master-Child Tables
Closed

Comments

  • Ralph started the conversation

    Hi


    I would like to show tow tables on one page.

    The top table is the master, the other the child or slave. The child table has a foreign key that points to the master.

    I want the child table to refresh and show only the dependent records when the focus goes to another record in the master table.

    When I add to the child table, I want the foreign key to automatically fill with the Id of the selected record win the master table.

    Is this possible, and how is it done?

    If not on one page, can it be done on two pages?

    Thank you

    Ralph

  •  2,498
    Aleksandar replied

    Hello again Ralph.

    You can link some columns between these two tables with Foreign Keys, that's true.

    However, having a functionality that the child table shows only the records when the focus goes to another record in the master table, and filling in the ID automatically is not possible with the plugin's built in features.

    This would require some serious customization, which unfortunately isn't included in the provided support of the plugin. While we do offer customization services, due to the amount of work on our hands, all customization is being stopped.

    It probably can be done, but our developers are very busy at the moment, working on some priority tasks and fixing bugs and issues with our plugins, so they won't be having the time for custom work in near future.

    But we can recommend these services for customization:

    https://codeable.io/?ref=l1TW1

    https://wpkraken.io/?tms-plugins

    They do develop such solutions, so can you please send your inquiry to them?

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

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

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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

  • Ralph replied

    As I said in a another reply, Alexander, I am not in the position to pay for custom software.

    In a support ticket from early 2018 you talked about having such a component on the radar, and all I wanted to know is whether you have built it already.

    Is there a filter or an action when the record of a table is selected? 

    Can I from PHP determine the key of the table that is selected at the moment? I would use it then to call a new page with a wdt_column_filter() on a hidden column to simulate the master-detail relationship.

    Is there some code snippets that could be used to add records to the table adding the master key before editing (instead of the built in functionality of New entry)? I would then use buttons to add a new child record.

    Can you offer any help or hint but custom built software?

  •  2,498
    Aleksandar replied

    Hi again Ralph.

    Our team is currently working on adding this as well, but unfortunately it will not be included in the initial release of Master-detail. Our development team still needs to explore which hooks and filers can be used for that, so unfortunately I cannot give you any hints, since the lead developer working on this hasn't tested it yet.

    You're welcome to do any custom work using our filters and hooks, but please note that they are not included in the provided support for the plugin. I'd love to share some hints with you, but unfortunately I don't have any at the moment.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

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

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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