Duplicate Record Removal

[NDNobbs]

I have a database to monitor training. Each form has the Code, Name, Training
(several), a check box for each year to show the training was completed and a
field that shows the date it was completed.

I add fields due to new training requirements. Now, for some reason, there
is a duplicate record for every employee listed.

What did I do? How do I make it stop?

Thank you!

 

[Jerry Whittle]

First thing is to stop adding field to the table for each training
requirement. What you need is at least 3 tables.

1. Personnel. All the information about the person needing the training.
Make sure to have a primary key set for this table.

2. Course. All the info about the course of training. Ditto on the primary
key.

3. Class. This is a bridging or linking table between Personnel and Course.
It will have a field for each of these tables so that you can put in the
primary key data for each. It will also have a date field. That way you can
write a query to see who took what course and when.

Note that you don't need both a year and date field as you can derive the
year from the date using the Year function.