AnsweredAssumed Answered

Medical database structural build problems

Question asked by Antonio on Jan 1, 2012
Latest reply on Jan 17, 2012 by philmodjunk

Title

Medical database structural build problems

Post

I have been using a database I designed (with tremendous help from this forum). It has primarly been an invoice databae. 

Now I want to add my medical record keeping and need some help pulling it off. I have the following tables that I need to relate.

PATIENTS

CASES (each patient may come for multple cases or for mutliple reasons over time)

TREATMENTS (each patent will receive multiple treatments but each treatment will be realated to only one case)

INVOICES (Currently I am planning to keep the treatments and the cases seperate from the invoices but it could be helpful to link them)

I am attaching a screenshot of the current setup.

Outcomes