5 Replies Latest reply: Jun 14, 2016 2:04 PM by YUN BAI RSS

    Customize sort order

    YUN BAI

      Hi,

       

      I try to use Load Inline (shows as below) to create the customized sort value of "Report Type" in table B.

         

      However, I want to connect table B with another table A with "Case ID" as the primary key. I also want to add data field "Case Date" in table B.

       

      My question is can I add "Case ID" and "Case Date" in table B? If so, where I should place them?

      It shows error if I do this:

      Load

             Case ID,

             Case Date

      Inline [

      Report Type

          Spontaneous

          Report from Study

          Others

      ];

       

      Thanks in advance,

      Becky