Please see the file attached, and look on it's script.
In this file I have 3 tables:
SerialCakes: The serial number for each cake, and it's request quantity.
RecipeIngredients: Cake ingredient + coefficient(quant for 1 cake).
Transorder: list of the De-facto consumption.
In the GUI I created 2 straight tables: "Recipe Ingredients", "De Facto".
What I want to show is a straight tables that compare the values from "Recipe Ingredients" and "De Facto".
If I select "Sponge cake", I want to show a compare straight table like this:
|De Facto||Gap (Resipe - De Facto)|
How can I do that (without changing the tables links, all the tables link with serial.serial)?
Hope that is clear, and tks for your ideas...