R
ryguy7272
Hello! I am trying to come up with a process of letting several users
interact with Access Forms to assist patients with their healthcare needs.
Initially, I developed one single Form that allows a user to enter all
relevant information into a Table. This works fine. Now, I am told that it
would be better design to allow users to work with different Forms depending
on different stages of the process of providing healthcare. I have a fuzzy
idea of how to handle this, but I would really appreciate some guidance! I
was thinking of using some kind of master From which contains the current
date and based on the date, display certain other Forms. For instance, The
‘ConsultForm’ would be displayed initially. Some information, along with a
‘Simulation Date’ would be entered (into the Table) using this ConsultForm.
If the SimDate was one week from today, and the user was in the DB one week
from today, he/she could see the Form named ‘SimulaitonDate’ popup and know
they these patients needed care. Then there is a follow up, about a week
later, for treatment, handled with the ‘TreatmentForm’, and then there is a
status checkup, handled with a ‘StatsForm’. I guess I am just wondering if
it makes sense to cause certain Forms to popup, and display patient records,
depending on today’s data and the stage of the treatment process. Is this a
good DB design? Would someone recommend something else? Should I use
conditional formatting somewhere? Does anyone know of a sample DB out there
somewhere that does something similar to this?
Thanks so much for your valuable time!!
Regards,
Ryan---
interact with Access Forms to assist patients with their healthcare needs.
Initially, I developed one single Form that allows a user to enter all
relevant information into a Table. This works fine. Now, I am told that it
would be better design to allow users to work with different Forms depending
on different stages of the process of providing healthcare. I have a fuzzy
idea of how to handle this, but I would really appreciate some guidance! I
was thinking of using some kind of master From which contains the current
date and based on the date, display certain other Forms. For instance, The
‘ConsultForm’ would be displayed initially. Some information, along with a
‘Simulation Date’ would be entered (into the Table) using this ConsultForm.
If the SimDate was one week from today, and the user was in the DB one week
from today, he/she could see the Form named ‘SimulaitonDate’ popup and know
they these patients needed care. Then there is a follow up, about a week
later, for treatment, handled with the ‘TreatmentForm’, and then there is a
status checkup, handled with a ‘StatsForm’. I guess I am just wondering if
it makes sense to cause certain Forms to popup, and display patient records,
depending on today’s data and the stage of the treatment process. Is this a
good DB design? Would someone recommend something else? Should I use
conditional formatting somewhere? Does anyone know of a sample DB out there
somewhere that does something similar to this?
Thanks so much for your valuable time!!
Regards,
Ryan---