Recent content by cereo

Pat, thanks for your reply. tbl_TrainingEvents has a field for the Document, will that do the same thing, i.e. let me relate the employee's training to the document? That's where I was headed, but you might be seeing something I am missing.

Great! I'll give that a whirl. Thanks!

Thanks, spikepl. I'm assuming you mean for me to enforce RI all the way around, yes? I'm not sure how that will help with the problem of building a query that will yield a result like, Employee X with Job Description Y had training on Document 1A but not Document 1B. Am I just being thick headed?

I hope someone can help me solve this puzzle: I am designing a database that will link documents to training events on those documents and the employees present at the training events. The employees needing the training is determined by the employee’s job description. Tables: (jt represents...

Thank you, Sean. I'll give that a try. Now I just need to learn how to "thank" you in this forum!!

I am awed by the time you took to work on this and how thorough your answer! Thank you, Beetle! I have attached some screenshots that might help you see where I am going wrong. You wrote I can't look at your db because I don't have A2007/2010 where I am, but to answer your question, the combo...

Hi, I am no programmer and my Access training has big holes in it but I will try to be clear. I have attached a small part of the database I am building to keep track of employees and the training they have taken or need to take based on their job descriptions. I created a form based on...