lizcliff
Registered User.
- Local time
- Today, 11:20
- Joined
- Feb 23, 2013
- Messages
- 38
I am creating a database to capture new referral information. So I have a patient table and a referral table to capture the data.
I have created a form to set up new patients to add to the patient table. Patient number combo box has a control source of patient number from the patient table and the row source is based on a query to a linked table pulling all the relevant patient details through. The patient number saves to the patient table but the other details I am pulling through into the form using text boxes control source =patientnumber.column(2) etc. are not? am I missing something...
my next part would be to open referral form to log referral information on that patient - how do I get the patient number to automatically open up on the referral form so I get that link?
thanks for your help
I have set up the patients table with a primary Key of patientID - autonum and referrals table with primary key RefId autonum, including field patientID to link to patients table so I can add them as relationships
I have created a form to set up new patients to add to the patient table. Patient number combo box has a control source of patient number from the patient table and the row source is based on a query to a linked table pulling all the relevant patient details through. The patient number saves to the patient table but the other details I am pulling through into the form using text boxes control source =patientnumber.column(2) etc. are not? am I missing something...
my next part would be to open referral form to log referral information on that patient - how do I get the patient number to automatically open up on the referral form so I get that link?
thanks for your help
I have set up the patients table with a primary Key of patientID - autonum and referrals table with primary key RefId autonum, including field patientID to link to patients table so I can add them as relationships