hi Folks
Would really appreciate your help with this..essentially these forms are to track treatments (each of which has a number of sessions for customers)
I have 3 forms: Main form for Patients (mFrmPatientDetails) .I have this set up as with combo box: (There is an underlying tblPatients table which has all their details)
PatientID
PatientName
PatientMR
Then I have the subform (sFrmTreatment) in this based on treatment table: tblTreatment
TreatmentID (PK)
PatientID (FK)
DateofFirstTreatment
Treatment number (to be entered by user)
This sFrmTreatment form will have a subform (subsFrmSessions)
SessionID (PK)
TreatmentID (FK)
PatientID (FK)
session descriptions etc.
So far they all link together correctly but I did this before on another database and the forms did not always work well together :-(
How can I set up these forms to do the following for the user?
sFrmTreatment
Show Patient Name and MR rather than Patient ID but in the background be using the PatientID to link together. So that the users are sure who they are entering the data for
Treatment number to increment for that patient (would it be enough to have that set up as an autonumber ?)
What I am noticing is that when I choose a new patient from the combo box - that doesn't seem to update the mFrmPatientDetails (because I have also left the PatientID
PatientName
PatientMR visible so I can check...
Essentially what I want is the following..
User picks up patient from combo box.
They add the treatment number and date of commencing treatment. They can move (via buttons back and forth between the treatments for that patient)
They can view the details of the multiple sessions for each treatment for that patient...
What do I need to do to make this more stable (and also hide the ID keys as much as possible from the user)
Thanks
Anne
Would really appreciate your help with this..essentially these forms are to track treatments (each of which has a number of sessions for customers)
I have 3 forms: Main form for Patients (mFrmPatientDetails) .I have this set up as with combo box: (There is an underlying tblPatients table which has all their details)
PatientID
PatientName
PatientMR
Then I have the subform (sFrmTreatment) in this based on treatment table: tblTreatment
TreatmentID (PK)
PatientID (FK)
DateofFirstTreatment
Treatment number (to be entered by user)
This sFrmTreatment form will have a subform (subsFrmSessions)
SessionID (PK)
TreatmentID (FK)
PatientID (FK)
session descriptions etc.
So far they all link together correctly but I did this before on another database and the forms did not always work well together :-(
How can I set up these forms to do the following for the user?
sFrmTreatment
Show Patient Name and MR rather than Patient ID but in the background be using the PatientID to link together. So that the users are sure who they are entering the data for
Treatment number to increment for that patient (would it be enough to have that set up as an autonumber ?)
What I am noticing is that when I choose a new patient from the combo box - that doesn't seem to update the mFrmPatientDetails (because I have also left the PatientID
PatientName
PatientMR visible so I can check...
Essentially what I want is the following..
User picks up patient from combo box.
They add the treatment number and date of commencing treatment. They can move (via buttons back and forth between the treatments for that patient)
They can view the details of the multiple sessions for each treatment for that patient...
What do I need to do to make this more stable (and also hide the ID keys as much as possible from the user)
Thanks
Anne
