Recent content by cereo

  1. C

    Question Should I NOT enforce referential integrity in this case?

    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.
  2. C

    Question Should I NOT enforce referential integrity in this case?

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

    Question Should I NOT enforce referential integrity in this case?

    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?
  4. C

    Question Should I NOT enforce referential integrity in this case?

    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...
  5. C

    Need to populate junction table from form, please help

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

    Need to populate junction table from form, please help

    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...
  7. C

    Need to populate junction table from form, please help

    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...
Back
Top Bottom