table design to manage patients

[Rich]

I'm sure Fizzio posted something similar back along, try searching for posts by him

 

[Lohengrin]

patient Tracker

I see you have been challenged by the same problem I have been. I was able to create something similar to a patiant chart for my Ipaq using syware relational database--a third paty version of pocket access.


I found I created tables of symptoms,character, duation, severity . . .and the other seven dimensions of ech symptom. The syware software allowed for "multitiered dependent drop downs" which are similar to the cascading comboboxes used for access. The major advantage was the abiolity to query another table by ID number and then direct that the associated text be added to a table directly. What is created is really a lookup function with all its problems.

Not surprisingly with all this essentially on a flat file the source tables grew exponentially with each parameter (or each question as you described things) I went through four columns before I reached >7000 entries and choked the Ipaq RAM.
Files are enormous ~3Mb and I needed tedious hours with excel and importing shananagens (sic) to get it to work, but with some limitations I can track meds and symptoms with an Ipaq.

Enough of that I am now attempting to do the same in access for the desktop and am running into the same difficulties you are. Access should be easier but I am only able to produce a table of IDs with cascading comboboxes.

Tomorrow I will pencil draw the file structure I think works and post it. See my feeble attempt at cascading comboboxes in the utteraccess forums. Pat Hartman, rowiga and others deserve credit for helping me there.

Lohengrin.

New Hampshire

 

[Lohengrin]

Can't Move Text with comboboxes in Patient Tracker

I have a general question that I think the answer will help many folks. I wish to be able to move text from an already existing table to another destination using comboboxes (or List and check boxes for that matter). The data is duplicated in the database (I see that is a no no) but it is in new combinations.

An example will be helpful. A patient presents with a symptom and the physician asks multiple questions to define the symptom. What is character?, Can you define the sensation better?, How severe ist?. . .Questions whose answers can be considered parameters which in many cases are frequently heard and can be maintained in a table as a list and just moved around when the answer is documented.

In a sense the database is used in reverse. Taking text from the database rather than inputting text. Putting it elswhere is like adding a quick text to a word processing program.

Enclosed is my structure for such a database with the obvious deficiency of not knowing how to to move the text around. I put no text in but the principle I hope obvious.

Elsewhere I attempted to do this with a medicaiton tracker and was only successful in moving ID numbers around and cannot regroup an id to the text it identifies.

Thanks for any help in advance,

Lohengrin

New Hampshire

 

[Lohengrin]

forgot winzip and attachment

I forgot both the attachment and that this terminal has no winzip.

More later

 

[Lohengrin]

attachment problem

here at least is the table lis I

tblSympt
SymptID (PK)
Symptom

tblCharacter
CharID (PK)
SymptID (FK)
Char

tblDefinition
DefID (PK)
SymptID (FK)
Definition

TblSeverity
SevID (PK)
SymptID (FK)
Severity

tblPertinentPos
PPID (PK)
SymptID (FK)
PertPos

tblPertinentNeg
PnegID (PK)
SymptID (FK)
PertNeg

tblOnset
OnsetID
Onset

tblDuration
DurationID
Duration

tblProgression
ProgressionID
Progression

tblMiscellan
MiscellanID
Miscellan