Hi there,

I would like to know if it is possible to connect data from one table with another table withing this plugin and / or any add-ons. To clearefy see following situation:

TABLE 1. This table is for adding / changing / removing contact information of various mechanics. This one should contain the persons data such as name, phone number, address and company name of the mechanic. This table needs to be searchable.

TABLE 2. This table is for adding / changing / removing project work logs. This one should contain information such as date, time, location and discription. But also the name of the mechanic that worked on this project.

Is it possible to add 'John Doe' as a mechanic to TABLE 1 (with all his contact information) and then add a work log to TABLE 2 and then select 'John Doe' has worked on this project?

---

I think I found this option here https://wpdatatables.com/documentation/front-end-editing/configuring-table-relations-foreign-key/.

Additional: Is it possible to make the employee (mechanic) name clickable in TABLE 2 so the employees contact details are popping up?