Table structure help

[oxicottin]

Hello, I want to fix a database I built and I needed some help on the table structure since its saving the data and not the ID number. I have it done and it works but its not correct since I dont understand normalization very well I took the easy way out and now its killing me and I want to fix it. Please take a look and give me some advise or show me a structure on what I need to do to normalize the DB... This would be my first DB so bare with me....

The comments section of each category will have a list of positive phrases and negative phrase equal to the subject like Safety, Quality, Quanity ect. "I didnt pur the phrases in each table yet"

Thanks!

 

[Guus2005]

The structure is here: http://en.wikipedia.org/wiki/Database_normalization

Looking at your edit status, is your problem fixed?

 

[oxicottin]

The structure is here: http://en.wikipedia.org/wiki/Database_normalization

Looking at your edit status, is your problem fixed?

Well sorta, I got it to save the ID for everything but the information from the employee info on the main form. Which is fine! But a I want to add a current employee check box in the frmUpdate employees and when I do a search in the switchboard it would bring up current employees. I have no clue as how to do this. Im attaching what I have so far but without what I want to do (adding current employee). Thanks!