Need Help With Patient Database

Hi, I am a newb at databases and Access, I work in a hospital that does not yet have an electronic medical record, so I am trying to make a simple database for our trainees to input patient information and print out daily progress notes. There is no money to buy one that is already made, and I'm very much interested in learning the basics of database design.

Our system currently has 12 teams defined by colors (red, blue, green etc.), each with 2 interns (intern 1 and intern 2).

Currently my 3 tables are:

Teams:
Team_Id (autonumber, PK)
Team_Color (text)

Interns:
Intern_Id (autonumber, PK)
Team_Id (number)
Intern_number (text)

Patients:
Patient_Id (autonumber, PK)
Intern_Id (number)
Last Name:
First Name:
.
.
.
etc.

Teams are set up 1 to many with interns which is set up 1 to many with patients. I've already inputted all the team colors (red, blue, green etc.) and the interns (since there is a set number of these)

I'm having a few problems

1) on a basic note, how would you go about assigning a patient first a team color, then an intern. The way it is set up now I can assign them an intern who is already assigned a team. But then I have to pick through 24 interns (12 teams x 2 interns) to select the intern. Ideally I want to first select a team, which then narrows it down to only 2 interns.

2) is there a way on a form to display text in a combo box, but have the database enter a number in the actual database. The way I have it set up above, everything is assigned an autonumber. I want to set up an easy to use form for interns to enter patient info. If I want to assign a patient an intern I would like the combo box to say (intern 1, intern 2). However each intern is assigned an autonumber so in the form it lists autonumbers 1-24 (since there are 24 interns overall)

Sorry if I am not explaining this very well. Any help would be greatly appreciated!