You are dealing with mulitple Companies or Departments that all share the same ten Positions (Job Title?)
Or one company / department that has only ten positions?
The Contact | Employee | Client | People (choose one) having a job position seems logical. A drop down JobPostion Field would seem correct.
A Job Position having a People is an unusual approach.
Reports with Summaries would list the Job Positions filled by the people.
Let me tell you my situation. That might be helpful.
so I am creating a database for theatrical lighting designers to organize their cue lists and such.
i have created a "setup" table which allows the user to enter information like the crew and other design team members.
each design team member has their own field.
what I would like is to have the user be able to select the title from a drop down menu which they can add custom titles and then enter in another field next to this one with the name of the person.
from all this information I would like a second table to be adding, subtracting, and editing each job title and its corresponding name as it changes.
in that other table each record has the name, job title, phone number, and email which will be the contact list of the team members.
does this make sense? If you could help me out that would be great!