Re: Help with counting please

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi John, and thanks for your time.
What I'm trying to track here is the diagnosis (and disease stage) of each
patient at the time of their initial visit to our program. Thus each patient
may have only one diagnosis & disease stage. So the structure is:

tblDisease
DiseaseID (autonumber)
Disease (text)

tblDiseaseStatus
DiseaseStatusID (autonumber)
DiseaseStatus

In tblPatients, DiseaseID is a number field, and in the form I use for data
entry (and the query based on tblPatients) there is a combo box which relates
back to tblDisease so, for example, Acute Myeloid Leukemia can be chosen.
Similarly in tblPatients, DiseaseStatusID is a number field, and in the form
I use for data entry (and in the query based on tblPatients) there is a combo
box which relates back to tblDiseaseStatus so that, for example, Relapsed or
No Prior Treatment can be selected.

I hope that makes it more clear.

What I want is to be able to tally the number of patients with each disease
by disease status, ie. the number of non-Hodgkins lymphoma patients who have
relapsed disease, the number of multiple myeloma patients who have had no
prior therapy, etc.

Your help will be greatly appreciated!
--
Thanks for your time!


"John W. Vinson" wrote:

On Thu, 7 Jun 2007 04:17:00 -0700, Sue <Sue@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

tblPatient contains the following fields:
DiagnosisID (foreign key from tblDiagnosis)
DiseaseStatusID (foreign key from tblDiseaseStatus)
ScreenStatusID (foreign key from tblScreenStatus)

Um????

This appears to be incorrectly set up. Surely each Patient may have many
Diagnoses, and each Diagnosis can apply to many Patients... a many to many
relationship. What's in tblDiagnosis? Is this a list of all the valid
diagnosis codes and condition names?

Similarly for the other tables... what is the actual structure of your tables?

The foreign key should - MUST - be in the "many" side table. If you have a
DiagnosisID field in the Patient table then you're saying that the patient can
have either zero or one conditions, never more. That would be nice, but I
would need four DiagnosisID's myself, right now!

John W. Vinson [MVP]

.

Relevant Pages

  • An interesting case study
    ... Progression of renal failure without proteinuria in a patient with type 1 ... Under the working diagnosis of a non-diabetic renal disease, ... The patient suffered from severe hypothyroidism. ... and thyroid hormones were tested. ...
    (misc.health.diabetes)
  • Re: Rita Heres a Post on that AWFUL Cal Legislation
    ... >>> Yee, PhD., to introduce legislation to protect physicians treating ... >>> chronic Lyme disease patients in California. ... The details about the bill follow. ... >>> rendered to a patient is innovative care or conforms to a different ...
    (sci.med.diseases.lyme)
  • Name that Disease! A new sci med lyme game!
    ... DISEASE???{in each description, the letter 'X' denotes the disease} ... patient exhibited delusions of persecution. ... lists at least 25 symptoms, including apathy, ... depression, behavioral changes, including frank confusional psychosis ...
    (sci.med.diseases.lyme)
  • HOW DISEASES ARE CURED - Orthopathy
    ... of disease and of the "complications" that so frequently develop under ... with the patient nor what to do for him. ... IS PATHOLOGY ITS OWN CAUSE? ... When a man becomes ill, he calls a physician, takes the drugs the ...
    (misc.health.alternative)
  • HUGE Progress - Symptoms of Alzheimers Reversed in MINUTES (By Americans, Of Course)
    ... An extraordinary new scientific study, which for the first time documents marked improvement in Alzheimer's disease within minutes of administration of a therapeutic molecule, has just been published in the Journal of Neuroinflammation. ... The new study documents a dramatic and unprecedented therapeutic effect in an Alzheimer's patient: improvement within minutes following delivery of perispinal etanercept, which is etanercept given by injection in the spine. ...
    (alt.politics)