Hello Nuno

Thank you for your interest in the plugin.

We don't have this built-in yet, but you can try with a workaround. Please note that this does require some experience with writing SQL queries and using WP hooks.

You can create a table with a query like this:

SELECT 
user_id, 
user_name, 
user_address,
CONCAT('<a href="http:/yoursite.com/your_custom_page?user_id=',user_id,'">Details</a>') AS Details
FROM your_table_name

Then, on your_custom_page you will insert a shortcode of the table ID that you need, with a placeholder like this:

[wpdatatable id=1 var1=1]

The second table would be created from a query like this:

SELECT * FROM second_table WHERE user_id = %VAR1%

After that, you can use a hook for dynamic placeholders:

function updateVAR1($tableID){  global $wdtVar1;      //check is set GET parametar user_id
    if(isset($_GET['user_id'])){
        //get value from form fieald
        $wdtVar1 = $_GET['user_id'];
    }  }
add_action('wpdatatables_before_get_table_metadata', 'updateVAR1');

I hope this helps you achieve the results that you need.