Join Table/Reporting question
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.