The Area being Modelled is :-
Monitoring Naval Officers

Question: Sirs, I am creating a website that will be used by junior Naval Officers to
select mentors from a list of senior Naval Officers.

The seniors will have probably about 10 jobs (orders) that they have held from 2-3 in duration.

I want to create a database that will allow the juniors to search the jobs that seniors have
held that match their desires.

I am thinking of 10 tables, with the table 1 being the base senior officer info (name, rank,...)
and the tables 2-10 to list the orders that each of the seniors have held.

Table 2-10 would essentially be the same fields over and over again just going backward from most
recent to the oldest.

How do I set up the keys to make this work ?

I have a proposed schema that I can send along.

Thanks. any help would be appreciated, and I will upload any information after this is done to help
you website.

Spencer