Forum Discussion

IvanWeiss's avatar
IvanWeiss
Qrew Captain
6 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
IvanWeiss's avatar
IvanWeiss
Qrew Captain
6 years ago
Don, ideally it would look like the report I posted initially with my first request.  Looking for a single line with the Company Procedure, a listing of the departments it affects, the date it was modified last (so we can watch for old procedures) and who modifiied it.

But I want to be able to filter it by department.  This way a Project Manager can just filter out procedures that affect them.

I tried the summary table but that didnt work either as it doesnt let me add the other columns I need.

------------------------------
Ivan Weiss
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
Ivan.  Let's go back to the summary report.

You can have up to 6 levels of group by, so that is 6 columns. If you actually need more you can make a formula to combine 2 or more columns. Isn't that enough columns??

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------