7 Replies Latest reply: Aug 30, 2012 3:27 AM by Shubham Kumar RSS

    Master Calender with 4 date fields

      Hi everybody,

       

      I have read so much through this community, but I didn't find an answer to my question. I want to use list boxes for the date for the easy choice.

      I have tables with different datafields. In all of them is the key %Item, because I have to combine different tables over this field. So I could not make all date fields as key words, because I then have many synthetic keys =(

       

      For example only four tables: Purorder, Order, Stocks and Prognosis.

      The stocks shows me the past development. The prognosis the future based on the order.

      Now I want to make a master calender, which shows me all datas, from past over actual to future.

       

      I tried this:

       

      date:

      LOAD

           purorder.date AS %date

      RESIDENT purorder;

      JOIN LOAD

           order.date AS %date

      RESIDENT order;

      JOIN LOAD

           stocks.date AS %date

      RESIDENT stocks;
      JOIN LOAD

           prognosis.date AS %date

      RESIDENT prognosis;

       

      The Calender shows me now, all dates from purorder. I have also try to use the concatenate respect the JOIN, but the result ist the same. Has anyone an idea, where my mistake lies?

       

      Regards