kbrooks
Still learning
- Local time
- Yesterday, 20:05
- Joined
- May 15, 2001
- Messages
- 202
Hopefully I can explain myself correctly.
Our surgical department currently logs all surgeries in a big book. At the end of the month, they hand count how many of each type of surgeries. I am wanting to set up a database so that, once they enter the information, reporting can be pulled to avoid all that hand counting.
As of yet, no tables are set up. I'm trying to determine the best way to proceed first.
One of the things they record for each surgery is the patient's medical record number. This is a number that is assigned to the patient the first time they are registered at the hospital, is unique to that patient, and never changes. Another one is the patient's name, which kind of goes along with that.
On the form, I'd like for them to be able to pull from a list of medical record number/patient names that have all ready been entered. I know this is possible if there is a separate table with that information in it. I'd also like for them to be able to ADD a new patient/medical record # if the patient is not currently in their log.
I've done this before, but by a separate form.....Add a Patient, then go to another form for the actual log. And I'm sure that's not the best way.
TIA
Our surgical department currently logs all surgeries in a big book. At the end of the month, they hand count how many of each type of surgeries. I am wanting to set up a database so that, once they enter the information, reporting can be pulled to avoid all that hand counting.
As of yet, no tables are set up. I'm trying to determine the best way to proceed first.
One of the things they record for each surgery is the patient's medical record number. This is a number that is assigned to the patient the first time they are registered at the hospital, is unique to that patient, and never changes. Another one is the patient's name, which kind of goes along with that.
On the form, I'd like for them to be able to pull from a list of medical record number/patient names that have all ready been entered. I know this is possible if there is a separate table with that information in it. I'd also like for them to be able to ADD a new patient/medical record # if the patient is not currently in their log.
I've done this before, but by a separate form.....Add a Patient, then go to another form for the actual log. And I'm sure that's not the best way.
TIA
