Hello,
I am enjoying the wpDataTable plugin so far thanks but I have a question.

I am trying to see if I can create a process for calculating and storing inventories for bars and restaurants.

I have created a wpdatatable with product name and cost price that is the result of a formula.  Then I have another wpDataTable where I have a column set as a Foreign key with the relation set to show the product name in a list from the previous table and so far this part works correctly.
Then another column with a foreign key with the relation set to show the cost price from a formula column from the first table however nothing is displayed in the result.

Ideally when I select the product name in the second table from the foreign key I need other columns pulling the cost price and other formula values from the first table then be able to apply formulas to these. 

I have read the https://wpdatatables.com/documentation/front-end-editing/configuring-table-relations-foreign-key/
From what I can see I don't think it will be possible.
Perhaps it is too complicated but I thought I would ask to see if you can suggest a possible solution. 
Best Regards
Daniel