Need help assigning more than one person to a specific patient in scheduling

[labgirl]

I am working on only my second access database and am definitely a novice. I am creating a scheduling database for patient home visits and need to see specific people assigned to one visit, and it will always be at least 4. Could I create a drop down list that will show all team members? How would I design the scheduling table to have multiple people for one scheduling record? I have table for Teams and one for Team members, but when creating the appointment form realized I will only see one team member assigned to one specific appointment.

[June7]

Options:

4 assignment fields in visit record - this is not normalized structure

or

A child table of team members assigned to visit. This table would have a record for each visitID and memberID association, so up to 4 records for each visit.