I know how to use a junction table to link two tables in a form/subform but I am getting a bit confused when I add a third table.  I have Clients who from time to time go to the hospital. I want to keep track of my Clients hospital visits so I set up 3 tables. One for Clients, one for the Hospitals and one for Patient Information. An example of the tables looks like this (this is a short version):

Clients: ClientID - Autonumber
ClientFname - short text
ClientLname - short text

Hospitals: HospitalID - Autonumber
HospitalName - short text

PatientInfo: PatientInfoID - Autonumber
AdmissionDate - date/time
PatientNumber - short text

I figure that 3 tables are necessary because each client may go to more than one hospital and some or all may visit one hospital more than once.For example, if I have a client named Joe and he went to the ER at Mercy Hospital on 1/1/2000, then a week later he went into the ER again at Mercy, then one month later he went to Baptist Hospital, I need to keep track of the 2 admissions in Mercy and the one at Baptist. It seems simple when there are only 2 tables involved. I just use a form with a subform and create a junction table to hold the PK values. I am a bit confused as to how to get and store the values of the three PK in 3 separate tables. Any help is appreciated.  If there is an example I could look at that would really help.

---

Reply from Alex Hedley:

In your junction table just have the three id fields. You can then have a Form with 3 combos, one for each Table.
Then in your Query join the 3 tables to the JunctionT and pull in the Fields you want.