Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2017
    Location
    Batley, United Kingdom
    Posts
    19

    Seeking Design Advice

    Hello,

    I am planning to build a training database for my team at work and would like to get design advice before I start.

    What I am trying to do:.

    I want to have a list of processes that are assigned to specific departments.

    I want a form for employee training and what processes they need to be trained against.

    So when an employee is added to the database and they are added to a department, I want a list to generate with all the processes to be trained for that specific department.

    How would I go about doing this?

    Should i set up a table for processes which are linked to a department. Then when I select the department for an employee to processes list.

    How would I get this to work?

    I do not need a step by step, just a point of direction to take.



    Thank you.

    Regards,
    Mark

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Assuming that a process can be required by more than one department, I'm thinking a departments table, a processes table, and a many-to-many junction table with fields for department ID and process ID (and typically it's own autonumber primary key).
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. SQL Statement, Seeking advice
    By d9pierce1 in forum Programming
    Replies: 3
    Last Post: 12-28-2018, 09:01 AM
  2. Seeking Relationship Advice
    By kd2017 in forum Database Design
    Replies: 8
    Last Post: 02-06-2018, 05:37 PM
  3. Seeking Table Conversion Advice
    By justphilip2003 in forum Database Design
    Replies: 11
    Last Post: 04-30-2013, 07:48 AM
  4. Replies: 14
    Last Post: 02-08-2013, 03:06 PM
  5. design advice
    By Sarge, USMC in forum Database Design
    Replies: 4
    Last Post: 10-06-2010, 07:53 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums