Help with tracking of contract dates

[lushh]

i am currently working on an employee database using MS access 2003. i wanted to track all the contract dates of a certain employee. is that possible?

whenever the user would enter a new contract date for a certain employee, it will not overwrite the previous contract dates, hence it would add up to the list of the contract dates for that certain employee...

what could be the appropriate VBA command or function for that? i've tried to search for this function, but unfortuntely i wasn't able to find what i've been looking for. i would definitely appreciate all the help you guys can give. thank you so much. if you want to see the ms access file, here's the link:
http://www.gigafiles.co.uk/files/636/HRIS/human resource info system_2006-09-27.zip

 

[ColinEssex]

The contract dates should be held in a separate table and linked to the person table via an IDNo.

Col

 

[lushh]

i tried to create a form and subform with this query for the tracking of contracts:

SELECT tblPosition.PositionName, tblContract.StartDateContract, tblContract.EndDateContract, tblCompany.CompanyName, tblDealer.DealerName, tblOutlet.OutletName FROM (tblOutlet INNER JOIN (tblDealer INNER JOIN (tblCompany INNER JOIN tblPosition ON tblCompany.CompanyIDPK = tblPosition.CompanyIDFK) ON tblDealer.DealerIDPK = tblPosition.DealerIDFK) ON tblOutlet.OutletIDPK = tblPosition.OutletIDFK) INNER JOIN tblContract ON tblPosition.PositionIDPK = tblContract.PositionIDFK WHERE (((tblContract.EmployeeIDFK)=[frmEmployee2].[EmployeeIDPK]));

but it won't work..

if you want to check the actual ms access file, here is the link:

http://www.gigafiles.co.uk/files/636/human resource info system_2006-10-11.zip

the name of the form with the subform is frmEmployee2.

thanks a lot and sorry for the inconovenience...