First of all i want to thank you all for the reply to my previous posts. With the help of respectful members of this forum, i ve solved some problems with the disign. But there is a long way ahead of me... my knowledge especialy to vb is ... zero...
Now the problems i am facing to this effort are:
-Some of the exams(tests) performed by the lab include other tests. For examlpe bloodcount includes 20 tests. When the doctor asks for bloodcount, the lab must do all of the 20 tests. The order has only one test but this one test " includes " 20 results. The billing and the order is for one test (bloodcount). The same thing happens to quite a few tests.I ve made tables with the bloodcount results but i dont know if this is the proper solution.
-Each patient refers to a group, male, female and child. For these groups there are different normal values for each exam(test). I ve made a table with normal values with the pk of exams as fk, group pk as fk and as data the min an max normal values. Hpw can i link the report of the test results with the group?
-Should i have different tables for quality control tests? I ve made a table Quality control, with ExamId_fk and low, mean, high, values for each test linked with a quality control results table.
- Finally some results dont have numeric values. Some test have specific values as possitive or negative, other some text and other some preselected values. The results table, to result field refers only to numeric, or text, or lookup. One thing i think of is three result fields... is that right? The other proble is that the lookup field are different for the tests (where they are...)
Will it be better to have tables for each of these tests(exams)?
The work flow:
One person goes to a doctor. The doctor gives a paper with the tests. Now the tests must be selected (programed) to the db, performed by the analyzers and input the results. Each test is performed only by one analyzer, one analyzer can perform more than one test.
I m waiting for some help and suggestions.
With respect to all members Tony Walker
ps ... sorry about the Greek to some descpriptions