Alumni database: Storing previous employers

[Yogibear]

I'm having trouble figuring out how to store previous employers for my alumni. There is no going off here.

Tracking previous employer allows us to the see progress on an alum's career. So, I can't just create a column with "current" or "previous." I have to have a start and end date in order to properly analyze this set of data. I can't conceptualize what the table will look like (never mind the Form for data input). I have shed tears over this.

In my tbl Employers I know that alumni will have a one-to-many relationship.

tblBiographical
Primary key is alumni
alumni name
home address
etc.


tblEmployers


Foreign key is tied to alumni id (primary key in my bio table)
Employer name 1
Start date 1
End date 1
Employer name 2
start date 2
end date 2
Employer name 3
start date 3
end date 3
and so on......

I KNOW MY THINKNG IS INCORRECT. Can someone please guide me. I would greatly appreciate it. Thanking you in advance.....

[RayMilhon]

change tblemployers to the following
emphistoryid PK Autonumber
AlumniID FK
EmployerName Text
startdate datetime
enddate datetime

that's all you need.

[Yogibear]

Meant to write earlier, thank you for solving this problem that consumed me. FK didn't even enter my mind and now it all makes sense.