Set up a dynamic filter on a report in Parent table based on content in Child records

Question

My child table has ~50 possible values for a required text field. Each parent record has children representing some combination of these text values. Is there a way to set up a dynamic filter for a report on the parents table that would list all these possible values and enable users to filter by parents which are related to child records that contain specific values?

quickbasecoachd · Answer

I don't have a way to allow a Dynamic Filter, but I do know a way to search / filter via the filter box at the top of the report, if that is useful.

kingslysamuel · Answer

I am sure you must have thought of it and that you wanted this report to be on the parent table, but just from a report perspective, you can achieve the same result (report with these dynamic filters) in a child table, can't you?

quickbasecoachd · Answer

.. building&nbsp; on what Kigsly said above, you van use a Summary Report on the child table to get the result you are looking for.&nbsp; It is also possible to provide a link in the summary report which will take you to the Parent record instead of the children, as your goal is to get to a Parent, I believe.

alexgale · Answer

I did set up something like that, but feedback has been that using the dynamic filter feature would be a lot easier &amp; more intuitive.&nbsp;

quickbasecoachd · Answer

Then&nbsp; what about the Suggestion to use a Summary report which hyperlinks to the Parent

Forum Discussion

Set up a dynamic filter on a report in Parent table based on content in Child records

Related Content

Dynamic Rule - Or statement?

Custom Record Titles

Using Grid Edit to Edit Multiple Records at Once

Record Details

Prevent save a record - New forms