Hello All.
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".
For expl:
If I select "Sponge cake", I want to show a compare straight table like this:
PartName | PartDes | | De Facto | Gap (Resipe - De Facto) |
1008 | flour | 249 | 249 | 0 |
1009 | Sugar | 373.8 | 0 | 373.8 |
1015 | eggs | 1800 | 348 | 1452 |
1020 | rum | 60 | 0 | 60 |
1033 | Wine | 0 | 248 | -248 |
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...
Matan.