i've been working on a database that can track the contract dates of contractual employees in our company. do you have any idea on how am i going to structure a table that will include the following:

- The start date of the contract
- The end date of the contract

employees can be issued more than 1 contract.

i'd really appreciate your responses. thank you.

Well, since employees can be issued more than one contract, I'd have a separate table with the contract dates and times, with an employee ID field connecting it to the employee table.

Something like this:

Employees:

1 Smith Joe (other employee info)
2 Doe John (other employee info)

And then

Contracts:

1 03/06/2006 09/05/2006
1 09/06/2006 03/05/2007

Where 1 in the contracts represents the employee ID from above.

Originally Posted by ADAM Web Design

Well, since employees can be issued more than one contract, I'd have a separate table with the contract dates and times, with an employee ID field connecting it to the employee table.

Something like this:

Employees:

1 Smith Joe (other employee info)
2 Doe John (other employee info)

And then

Contracts:

1 03/06/2006 09/05/2006
1 09/06/2006 03/05/2007

Where 1 in the contracts represents the employee ID from above.

got it! thanks for the reply...