Best Practice design question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a db to track employees' requests for training and the priority they want that training.

Table:
tblCompanies
tblCourses
tblEmployees

The end goal is to have a web page where the employees can select their name from a combo box, then underneath have 5 spots for selecting different courses. The courses would be selected based on the priority the employee wants to take the course.

I think I need a fourth table to hold the results, something like tblEmployeePreferences or whatever, but I am unsure how to field it so that it is useful. I mean, I obviously have a lookup field for employee, then one for the course, and I'm assuming one for preference with values of 1-5. I am just unsure if this is the best way, and if so what would the recommendation be for creating a web page based off of that?


Thank you.
 
|
| I have created a db to track employees' requests for training and the
priority they want that training.

Table:
tblCompanies
tblCourses
tblEmployees

The end goal is to have a web page where the employees can select their
name from a combo box, then underneath have 5 spots for selecting different
courses. The courses would be selected based on the priority the employee
wants to take the course.

I think I need a fourth table to hold the results, something like
tblEmployeePreferences or whatever, but I am unsure how to field it so that
it is useful. I mean, I obviously have a lookup field for employee, then
one for the course, and I'm assuming one for preference with values of 1-5.
I am just unsure if this is the best way, and if so what would the
recommendation be for creating a web page based off of that?
-----------
Hi Gary,

You have a many-to-many relationship between employees and courses. To
break this, you need a EmployeeCourses table to store which courses an
employee will attend.

You then design a form/subform to enter employee details and the course
attended by each employee.

Hope this helps,
 
Ok, I have a tblEmployeePreferences (similar to tblEmployeeCourses you referenced), it has the following fields:
PreferenceID
EmployeeID
CourseID
PreferenceChoice (this is a drop down with 1st, 2nd...5th as values)

For my form frmEmployeePreferences I have a data record of qryEmployeePreferences (which is basically same as tblEmployeePreferences except rather than employeeID it has an expression to show first and last name).

I would like this form to basically be a web page in which the employee can select their name from the drop down box, then underneath have 5 boxes to choose course and 5 boxes next to those in order to select preference. Then a submit button at the bottom would write it all back to the database as individual records in tblEmployeePreferences.

The first problem I have is when I setup the form I can only put as many boxes as I want for courses, but when I select a course it changes all the boxes. I would like each of them to be considered a seperate record. Any ideas how to make this work would be greatly appreciated.

Thank you,
Pryde
 
Back
Top