Skip to main content
Question

Update Default Record Picker in Report


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. 

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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------