3 Replies Latest reply: Aug 26, 2011 4:44 PM by Bikash Debnath RSS

    Macro to select data from two separate table

      Hi Friends,

      It's been a long time.

      I recently came up with one situation, that I had to use two different table to bring data into one chart and

      those tables are not connected.

       

      In table A I have a field called FACT_TYPE(renamed as FACT_TYPE_A) and in table B I have a FACT_TYPE(renamed as FACT_TYPE_B).

      I have attached a sample application, could you please refer to that.

       

      What I need is a macro code that will select FACT_TYPE value from both table. Otherwise I had to select manually from both tables.

       

      Many a thanks beforehand,

       

      Regards,

      Bikash Debnath