Displaying fields from multiple related tables in list view
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.