I am creating an employee database. Currently I have a main employee table, and as I have viewed the last few lessons I realized that I need to take some things out and create separate tables. I am struggling with how to deal with the list of 12 certifications and their expiration dates that each employee may have. Currently I have fields for each cert and its expiration date, but it seems like that does not follow the rules of normalization. Should I create a many to many relationship? How would I use that to still keep track of expiration date? I would appreciate any feedback before I go farther in development. Thank you
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 2.