bwyrwitzke
Registered User.
- Local time
- Today, 15:47
- Joined
- Nov 11, 2002
- Messages
- 50
I'm working on a database for storing employee resumes but am struggling to pull it together.
I need to connect employees to employers to projects and am envisioning three tables:
tblPersonnel (key ID_personel) - basic employee data
tblEmployers (key ID_employers) - employer info, including employee start/end dates
tblProjects (key ID_project) - project title and description
Some employees will have many past employers and projects, while others will have few, so I imagine that each employee record will contain multiple employer records which will in turn contain multiple project records. The question I have now is how do I lay it out in a user friendly manner? Any help would be gratly appreciated. Thanks.
Bruce
I need to connect employees to employers to projects and am envisioning three tables:
tblPersonnel (key ID_personel) - basic employee data
tblEmployers (key ID_employers) - employer info, including employee start/end dates
tblProjects (key ID_project) - project title and description
Some employees will have many past employers and projects, while others will have few, so I imagine that each employee record will contain multiple employer records which will in turn contain multiple project records. The question I have now is how do I lay it out in a user friendly manner? Any help would be gratly appreciated. Thanks.
Bruce