keeping record of employee work history

[Bobie]

Hi Guys,
I am tasked to keep records of our employees which we are required to refer to time and again.
for example;
Bob currently works in a warehouse in organisation x
Bob has worked in the register
Bob has also worked in a customer service centre within the same organization x.
i want my access to display bob and other employees current work.
i also want to be able to refer to Bobs work history i.e all the places he has worked.
How can i achieve this in access. I'll be grateful for your assistance.

[PhilOfWalton]

You need 4 tables

TblEmployees
    EmployeeID         Autonumber
    EmployeeSurName    Text
    EmployeeFistName   Text
    etc.
    .....
 
TblJobs
   JobID               AutoNumber
   JobDescription      Text  (No Duplicates)
   etc.
   ....
 
TblOrganisations
   OrganisationID     AutoNumber
   Organisation       Text  No Duplicates
   etc.
   ....
 
 
TblJoinEmployeeJob
   EmployeeID         Long   Joint Key
   JobID              Long   Joint Key
   OrganisationID     Long   Joint Key
   FromDate           Date   Joint Key
   ToDate             Date
 

That way any employee can be linked to any job with start dates & end dates and which organisation he is working for.

Yo will probably need additional checks that the person not doing more than 1 job on a particular date

Phil

[Bobie]

Thanks Phil. let me try this one and revert