Hello Bruce

I'm sorry, but dynamically linking tables like this is not possible without some custom work.

If we assume you created a table using this query:

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');

This is the only way of using dynamic queries with the plugin, at the moment.