Training Database Design Help

[JGrots]

I'm going to add the RequiredTraining parameter back in. I took it out just to test the code and to see if all the topics got inputted into the TrainingTable.



So I can't create a new query that groups EmpID and CategoryID (see table below) and then if EmpID and CategoryID on the form don't match the query, input the topics?

EmployeeID	CategoryID
63	1
63	9
63	10
64	6

[orange]

Can you post a copy of the latest database, or is it the same as previously posted?

[JGrots]

Orange, I did the unique composite index and it worked like a charm! Thanks!

Here's the updated db:Training Database Test.mdb

[June7]

I've never bothered with setting indexes manually, composite or otherwise. I just tried with the TrainingTable and it didn't work. The INSERT still entered duplicate pairs. I know it's supposed to work but don't know what I'm missing.

EDIT: I see you got it to work. Congratulations!