Limit Dropdown Choices from Reports

Question

I feel like I'm missing something easy here....
In a form, when using a dropdown selector for records from any table, I can limit the choices to be based on filters in any report, among other easy methods.&nbsp; However, in a report or grid edit report, when selecting a record in grid edit, I can't find a method to limit that selection to certain criteria, based on that specific report.&nbsp; Can this be done?&nbsp;&nbsp;------------------------------Joe Hargrave------------------------------

miketamoush · Answer

Yes but this is not intuitive. You first need to make a new&nbsp;form on the child table - I would call it something like 'Grid Edit Form For xxxx Report'. On this form put all the fields you want the user to see when they grid edit. Typically, you just use the same fields that are already presented in the current grid edit, but you can choose any. Be sure your dropdown selector is there, and choose the filtered report.
Then on the forms settings page, expand 'Override Settings by Report'. Find the report that the user is grid editing (the one where the filters do not exist), and under Grid Edit Settings select the new form you just made (Grid Edit Form For xxxx Report').
------------------------------Mike Tamoush------------------------------

Forum Discussion

Limit Dropdown Choices from Reports