Discussions

Expand all | Collapse all

Trying to make an employee directory where employees are categorized by departments

  • 1.  Trying to make an employee directory where employees are categorized by departments

    Posted 08-31-2021 17:02
    I am trying to establish an employee directory where an employee can add their information and select the department they are apart of. From this, I would like all the employees of the same department to be categorized together automatically. I have an employees table and a departments table, however, I am not achieving the desired results. Any advice?

    ------------------------------
    Jasmine Sexton
    ------------------------------


  • 2.  RE: Trying to make an employee directory where employees are categorized by departments

    Posted 09-01-2021 02:32
    Hi Jasmine,

    Have you created a relationship between the employees and departments tables (where many employees may be associated with a single department)? If so, you should have what you need to:
    1. Allow employees to select from the list of departments
    2. View all employees in a department when you view the department record
    3. Create reports with a filter on department

    Were you looking to achieve something else?

    ------------------------------
    Jeremy Anson
    ------------------------------