Training DB Subform

[rramon]

Hello All,

2 question hope someone can help.

1. I'm building a DB to track employee training. An employee belongs to a department which has training specific to that department. I have made forms for each department with the courses as yes/no fields. I have a main form that has a drop down list of employees. Once an employee is chosen how do I get the form specific to his/her department to show as a subform?

2. There are 10 course that every department has to take. Should I add these course to each of the department forms or should I make a seperate form with only these course?

Thanks in advance for any help.

Rocky

 

[Navyguy]

Hi Rocky

I am probably the last person to be giving advice on access, and I hope somebody will correct me if I am wrong or at least giving poor advice...

I have been reading about normalization allot and just by your questions I think that you may need to have a look at how you tables are set-up.

My understanding is that if you have all these yes/no boxes for all your employees and courses, you literally have hundreds if not thousands of empty data cells that you are storing. There are many good explanations on normalization in this forum as well as on the net that can explain it better then I. Just as a simple example, your employees either have the course or they don’t…so why store that they don’t when you only really need to store what course they do have or the other way around, but not both.

If I am way off track please let me know, but I am thinking that if your tables are set-up a little differently you may be able to retrieve and input you data much easier then by using all your yes/no boxes and numerous subforms.

Just some food for thought

Navyguy

 

[Mile-O]

Spot on Navyguy.

rramon, are you saying that you've built different forms for different departments with their own respective courses. Is that the only difference?