Forum Discussion

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...

Qrew Cadet

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

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
------------------------------