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:
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?
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.
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
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 | 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
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?
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 | 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