Hello,
I am trying to create a database for a hospital to keep track of diabetic
and dialysis patients and their risk of foot ulceration. To make it easy for
the nurses to follow, we want to use text in the database that will represent
numbers so that an overall risk score can be calculated. We would like for
high=3, mod=2, and low=1 in the Vascular, Skin, mobility and Structure
columns. In the HbA1c column we would like for low and high=1 and stable=0.
In the diabetic column we would like for "n"=0 and "y"=1.

Here is an example of the layout:

Name Education Vascular Skin Diabetic Mobility HbA1c
Structure
a 7/8/2009 mod mod y mod stable mod
b 7/9/2009 high mod y low low low
c 7/10/2009 low low y high high high
d 7/11/2009 mod high n high stable low
e 7/12/2009 high mod n high stable low
f 7/13/2009 low low n high stable low
g 7/14/2009 low high y high low high
h 7/15/2009 low high y low high high
i 7/16/2009 high low n low stable high
j 7/17/2009 low high y low low mod
k 7/18/2009 mod high n low high high
l 7/19/2009 high high n low high high


Also, do you have any ideas about how to make a flag show up or some kind of
background change when the patients have not received education for 2 months
(under the Education column)?

I'm sorry if this is confusing!! Thanks.