ie: I have a "Client Portfolio" Table with their ivestments and I have a "Client Account" table with their personal details. Can I link their portfolio details to their account details?
The only way to link wpDataTables is by using Foreign Key feature. You can read more about it on Foreign key: Creating table relations in WordPress tables page from our documentation. Also you can make relation if you are creating MySQL based wpDataTables by using JOINs, but these tables can't be editable.
You can try our sandbox site: Front-end & Back-end - you can find a fully functional version there to try out all plugin features.
Can you link records in different tables?
ie: I have a "Client Portfolio" Table with their ivestments and I have a "Client Account" table with their personal details. Can I link their portfolio details to their account details?
Hi Jeremy,
Thank you for the inquiry.
The only way to link wpDataTables is by using Foreign Key feature. You can read more about it on Foreign key: Creating table relations in WordPress tables page from our documentation. Also you can make relation if you are creating MySQL based wpDataTables by using JOINs, but these tables can't be editable.
You can try our sandbox site: Front-end & Back-end - you can find a fully functional version there to try out all plugin features.