Access 2003 Multiple Entries

[Nan]

I am creating an employee database that contains employee's work history
organized by dates (i.e., 2003-2005, 1996-2003, etc). I currently have the
table set up by employee for each time period (i.e., employee ID 00001 has
five rows associated with his/her ID reflective of there work history by time
period. I'm questioning whether this is an efficient way to have set up this
table as I can not get a complete view of the work history on one screen
(form, page, report). Any suggestions? Thanks!

 

[Danny Seager]

Why can't you?

You should be able to create a report with the source of

SELECT * FROM TblEmployeeHistory WHERE UserID='00001'"

That should return all the records for that employee.

 

[KARL DEWEY]

I currently have the table set up by employee for each time period
You need two tables - one for employee and another for work history in a
one-to-many relationship. Each of the records on the many side would have
employee ID, start date, end date, grade/position, and reason end.
Use a form/subform to display employee/history.