AnsweredAssumed Answered

Displaying fields from multiple related tables in list view

Question asked by rkassis on May 30, 2013
Latest reply on Jun 7, 2013 by rkassis

Title

Displaying fields from multiple related tables in list view

Post

      Hello

     I am currently working on  health care database. In my database I have multiple tables For example, Main (patient info), laboratory results (as each patient may have multiple lab entries), hospital admission/encounters (patient may visist hospital many times), and treatment (patient may recieve many different types of chemo)

     What I want to do is to display all of the fields in these tables in a list view. I posted a picture of how I would like it to be. I want the records to be arranged by date. Each table has a field "date" In the picture light blue="lab", darkblue="hospital admissions" pink="diagnoses" and orange="treatment". In other words every color refers to a different table. So far I can't find any way to do this. Someone help me please.

      

     Thank you!

      

database_lab_report.jpg

Outcomes