Forum Discussion

JasmineSexton's avatar
Qrew Member
3 years ago

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

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

1 Reply

  • I suggest that you make a relationship where One Department has Many Employees. Then they can be grouped by department on a table report, or else the department record can show a report link embedded report if its Employees.

    Mark Shnier (YQC)