PRodgers4284
Registered User.
- Local time
- Today, 21:28
- Joined
- Feb 17, 2009
- Messages
- 64
I am working on a project atm that uses 3 tables with relationships between them. The tables are as follows:
Patientdetails tbl:
#PatientID (text field) input by user.
forename
surname
address etc.
age
date
etc
Admission tbl:
#EpisodeID (autonumber)
PatientID (text field)
unit
hospital
ward
consultant
etc
Patientquestion tbl:
#EpisodeID (number field)
PatientID (text field)
Trustname
Date
etc
I basically want the episode id to appear in the EpisodeID field in the patientquestion tbl, at present i have to enter the EpisodeID in manually which isnt very efficient. The users at present start by added a record to the patientdetail table with an patientref number for example H123, then an episode is added to the admissions tbl and the patientref number is input by the user along with other details of the patient admission. Then the user adds a record to the patientquestion tbl by inputting the episodeID created by the admissions tbl. The database needs to allow a patient to have 1 to many episodes as they may visit many times etc.
What i want to know is there a way a can add/update the EpisodeID to the patientquestion tbl without having to input it everytime for each visit? I dont know whether i have explained this properly but any help is much appreciated.
The table relationships are in the attachment below.
Patientdetails tbl:
#PatientID (text field) input by user.
forename
surname
address etc.
age
date
etc
Admission tbl:
#EpisodeID (autonumber)
PatientID (text field)
unit
hospital
ward
consultant
etc
Patientquestion tbl:
#EpisodeID (number field)
PatientID (text field)
Trustname
Date
etc
I basically want the episode id to appear in the EpisodeID field in the patientquestion tbl, at present i have to enter the EpisodeID in manually which isnt very efficient. The users at present start by added a record to the patientdetail table with an patientref number for example H123, then an episode is added to the admissions tbl and the patientref number is input by the user along with other details of the patient admission. Then the user adds a record to the patientquestion tbl by inputting the episodeID created by the admissions tbl. The database needs to allow a patient to have 1 to many episodes as they may visit many times etc.
What i want to know is there a way a can add/update the EpisodeID to the patientquestion tbl without having to input it everytime for each visit? I dont know whether i have explained this properly but any help is much appreciated.
The table relationships are in the attachment below.