AnsweredAssumed Answered

Join Table/Reporting question

Question asked by WendellNeeley on May 21, 2013
Latest reply on May 22, 2013 by WendellNeeley

Title

Join Table/Reporting question

Post

     I have three tables set up as below:

      

     New Exam >- Patient Demographic -< New Start

      

     I'm trying to use a report to get a ratio of the number of New Starts/New Exams (Fields in each table of same name).  I am assuming that I will need a join table or second table occurrence for this, but am unsure what is the best way to proceed.  The New Exam table and the New Start table have idential Patient Demographic PKs, yet I have been unsuccessful at making this work.  

      

     Any thoughts?  

Outcomes