469,921 Members | 2,179 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,921 developers. It's quick & easy.

Design Flaw?

Hi all, I have an issue with the design of my database. I have multiple
tables

Employee (empnum, emp lname, empfirst)
employee/jobcodes (empnum/jobcodes)
Jobcodes (jobcodes/jobcodesdesc)
Course(coursenum/course desc)
Training Required (jobcodes/course)

the employee(S) are assigned multiple jobcodes
the jobcode(S) determine the course(S)

My problem is I need another table that tracks training received.

Training Received (empnum, coursenum)

but I only want them to be able to receive training if the training is
required for their assigned jobcode(S) Can someone please tell me how
to setup the relationship betwwen training received and traing
required?

Nov 16 '05 #1
0 984

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

47 posts views Thread by Daniel Silva | last post: by
10 posts views Thread by ma740988 | last post: by
reply views Thread by Andrew | last post: by
6 posts views Thread by thomson | last post: by
reply views Thread by YellowFin Announcements | last post: by
4 posts views Thread by =?Utf-8?B?anAybXNmdA==?= | last post: by
reply views Thread by Waqarahmed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.