Compare 2 fields from 2 tables - With Set Analysis

[matancha]

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	Recipe	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.