Please help with employee database.

[andrewshuman]

How can I link the job and years of experience to the same employee without there being multiple rows
ie:
Instead of this
Bob Brown Manager 3 years
Bob Brown Talent 6 years
This:
Bob Brown Manager 3 years
Talent 3 years
Sallie Sue XXXXX Xyears
Also can the yoe and job title be two tables?

[Seth Schrock]

Here is a very simple table design using a normalized approach:

tblEmployees
EmpID     EmpName
1         Bob Brown
2         Sallie Sue
 
 
 tblExperience
ExpID     EmpID_fk    JobDesc     NumYears
1         1           Manager     3
2         1           Talent      6
3         2           xxxxxxx     x

Then in your employee form, you would have subform for your experience table with the relationship between the EmpID in tblEmployees and EmpID_fk as the foreign key in tblExperience.

[Rabbit]

Isn't this thread the same as your other one? http://bytes.com/topic/access/answer...tle-experience