0 Replies Latest reply: Jul 24, 2011 7:42 AM by Matan Chalamish RSS

    Compare 2 fields from 2 tables - With Set Analysis

    Matan Chalamish

      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:

      PartNamePartDes

       

      Recipe
      De FactoGap (Resipe - De Facto)
      1008flour2492490
      1009Sugar373.80373.8
      1015eggs18003481452
      1020rum60060
      1033Wine0248-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.