Update Default Record Picker in Report

Question

Hi!A relationship has been built between two tables: Resource Assignments and Ongoing Activities.The Ongoing Activities table houses a list of the Ongoing Activities that is used in the Resource Assignment form.&nbsp;In the Resource Assignment form, the Ongoing Activities drop-down list displays the active Ongoing Activity choices.However, in a report that was built (Resource Grid Edit) in the Resource Assignment table, the Ongoing Activity column/drop-down list is showing both the active and retired Ongoing Activity choices. Is there a way to only show the active choices?Note:

We chose to retire the ones we didn't need anymore as they were attached to previous Resource Assignment forms.
I went into the Advanced Settings, and "Resource Name" is the default record picker, which if at all possible we would like to keep as is.

Thank you!!------------------------------Clarice Dennison------------------------------

markshnier__you · Answer

Is your question this?"I know how to filter a drop down list on a form but how do I filter the drop-down list when I'm in grid edit mode?"------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

claricedennison · Answer

Possibly? Maybe I'm using different terminology. In the screen shot below, the drop down lists are different. I'm trying to figure out how to make them the same, and filter out the retired entries in the grid edit report drop down. Thanks!!
------------------------------Clarice Dennison------------------------------

markshnier__you · Answer

You will need to make a dummy form called, I suggest, "Grid Edit". Set the fields on the form to be in the same sequence as your grid edit report. Set the drop down for the "form" to use the same filtered drop down list as your main form has.

Then go to Forms Usage under the Forms menu, and set that report you are using to use the form called Grid Edit, for Grid Edit.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

claricedennison · Answer

Thanks Mark!I've created a dummy form. I'm probaby missing it, but I don't see the Forms menu.&nbsp;Should I be looking at a different area than the two screen shots below?------------------------------Clarice Dennison------------------------------

markshnier__you · Answer

@Clarice. I see it in your screen shot. Twist open the section for Override Role settings by Report.------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------

Forum Discussion

Update Default Record Picker in Report