Linking forms

K

Katie

I have a database with tables:

referral
patient
GP
Psychologist
Referee
Consultation

I want to begin by entering referral details into a referral form - this
will involve entering the patientNo that the referral relates to( the foregin
key linking the patient and referral tables) I then want to be able to open a
patient form and have the patientNo carried over into the patient form readt
to enter the patient details - i hope this makes sense...

I'm sure this should be easy but i can't seem to do it

Thanks
 
Top