Thanks to those of you who reponded to my recent post, but I may not have explained my problem clearly.
1. I want to have a table to list all my patients, with data such as:
name
address
birth date
etc. (one record for each patient)
I must be able to add records to this table independent of anything described below.
2. I want to have a table that lists various problems, such as:
diabetes
well child care
hypertension
etc. (one record for each problem)
3. I want a table or set that lists various follow-up items appropriate for each problem, such as:
recheck in 3 months
CBC
Blood pressure
etc. (several items for each proble)
I want to be able to go to this table or set, choose a problem previously listed under item 2. (but be prevented from listing any new problems), and add as many follow-up items as I want.
4. I want to have a table or set which will allow me to pick any previously registered patient (but not add new ones), and add a record for each problem that that patient has and have the system add a record for each follow-up item for each problem.
Records in this table or set might be like�
NAME PROBLEM FOLLOW-UP
John Smith1 hypertension2 BP check every 3 months3
John Smith1 hypertension2 Chem 7 every year3
Ann Jones1 hypertension2 BP check every 3 months3
Ann Jones1 hypertension2 Chem 7 every year3
Ann Jones1 diabetes 22 HgbA1c every 2 months3
Ann Jones1 diabetes 22 Ophthalmologist every year3
the superscripts indicate the tables from which items have been taken. This final table or set would then be used to create follow-up ticklers.
How do I do all that?
Conrad
1. I want to have a table to list all my patients, with data such as:
name
address
birth date
etc. (one record for each patient)
I must be able to add records to this table independent of anything described below.
2. I want to have a table that lists various problems, such as:
diabetes
well child care
hypertension
etc. (one record for each problem)
3. I want a table or set that lists various follow-up items appropriate for each problem, such as:
recheck in 3 months
CBC
Blood pressure
etc. (several items for each proble)
I want to be able to go to this table or set, choose a problem previously listed under item 2. (but be prevented from listing any new problems), and add as many follow-up items as I want.
4. I want to have a table or set which will allow me to pick any previously registered patient (but not add new ones), and add a record for each problem that that patient has and have the system add a record for each follow-up item for each problem.
Records in this table or set might be like�
NAME PROBLEM FOLLOW-UP
John Smith1 hypertension2 BP check every 3 months3
John Smith1 hypertension2 Chem 7 every year3
Ann Jones1 hypertension2 BP check every 3 months3
Ann Jones1 hypertension2 Chem 7 every year3
Ann Jones1 diabetes 22 HgbA1c every 2 months3
Ann Jones1 diabetes 22 Ophthalmologist every year3
the superscripts indicate the tables from which items have been taken. This final table or set would then be used to create follow-up ticklers.
How do I do all that?
Conrad
Comment