Forum Discussion

JasmineSexton's avatar
JasmineSexton
Qrew Member
4 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...
Relationships
JeremyAnson's avatar
JeremyAnson
Qrew Cadet
4 years ago
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
------------------------------