Forum Discussion

IvanWeiss's avatar
IvanWeiss
Qrew Captain
5 years ago

Cannot Dynamic Filter in Many to Many Relationship

I am creating a table for all of my Company Procedures so that we can work on documenting them for new and existing employees.  As this list can get a bit long I want to be able to associate a Departm...
Many-to-Many
Relationships
reports and charts
JasonJohnson2's avatar
JasonJohnson2
Qrew Cadet
5 years ago
I would have made procedures a stand alone with the Departments Affected By field being a multi-Text Select but make the selections come from the Department Name field in the Departments table. Then you could make the role show only records that contain the users department in the Departments Affected By field.

------------------------------
Jason Johnson
------------------------------
  • IvanWeiss's avatar
    IvanWeiss
    Qrew Captain
    5 years ago
    But dont I need a many to many relationship here?  A procedure is going to be related to a few departments.  Each department will have a bunch of procedures.

    ------------------------------
    Ivan Weiss
    ------------------------------