J
Johanna Gronlund
Hello,
I have 3 tables: PatientDetails, ReferralDetails and EnvelopeDetails
PatientDetails and ReferralDetails are linked by ReferralCode.
ReferralsDetails and EnvelopeDetails are linked by SentEnvelope field.
I need a form that only shows those patients who do not have SentEnvelope
against their ReferralCode (and hence PatientID). This I have managed to do
by using a query and then the form wizard.
However, what I need to do now is to be able to update everyones
SentEnvelope field with relevant envelope id. Every patient that is referred
will have a referral details in the ReferralDetails table. The
EnvelopeDetails table contains details of the envelope that is sent to the
hospital with several patients referrals in them.
The aim of this is to be able to quicky identify patients who have not yet
have their referral sent to the hospital (nothing in the SentEnvelope field).
Then I want to be able to update this field with the relevant EnvelopeDetails.
Many thanks for your help.
I have 3 tables: PatientDetails, ReferralDetails and EnvelopeDetails
PatientDetails and ReferralDetails are linked by ReferralCode.
ReferralsDetails and EnvelopeDetails are linked by SentEnvelope field.
I need a form that only shows those patients who do not have SentEnvelope
against their ReferralCode (and hence PatientID). This I have managed to do
by using a query and then the form wizard.
However, what I need to do now is to be able to update everyones
SentEnvelope field with relevant envelope id. Every patient that is referred
will have a referral details in the ReferralDetails table. The
EnvelopeDetails table contains details of the envelope that is sent to the
hospital with several patients referrals in them.
The aim of this is to be able to quicky identify patients who have not yet
have their referral sent to the hospital (nothing in the SentEnvelope field).
Then I want to be able to update this field with the relevant EnvelopeDetails.
Many thanks for your help.