3 Replies Latest reply: Oct 5, 2012 8:16 AM by jagan mohan rao appala RSS

    How to Solve this?

    Kabilan Kumarasamy

      Hi all,

       

      I have a issue.

       

      How to make a link between table ?

       

      I have three table 1.Start_Date 2.End_date 3. Info_Table

       

      These all table linked like below.

       

      Capture.PNG

       

      And I have a table like this:

      Start_date:

      Key_counter     Start_time

      1                         00:00:07

      2                         23:59:57

       

      End_date:

      Key_counter     End_time

      1                         00:00:07

      2                         00:00:07

       

      InfoTable:

       

      Key_Date                     Category      QvdName

      (this is a field used

      to generate the start

      time and end time)

      2012/09/06 23:59:57                            

      2012/09/07 00:00:07               Original          Invoice_tab_Aeprod_2012-08.qvd

      2012/09/07 00:00:07               Original          Invoice_tab_Aeprod_2012-09.qvd

       

      So now issue is If I select the qvd name directly start time and end time list box like this.

       

      Capture1.PNG


      But I wan tlike this ..

      Capture2.PNG

       

      May be this issue reason is key generation.

       

      And I have attached the script Please find that.

       

      Please help me...!

       

       

      Thanks in advance..

       

      Regards,

      Kabilan K.