Forum Discussion
MarkShnier__You
3 years agoQrew Legend
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
------------------------------
"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
3 years agoQrew Trainee
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
------------------------------
------------------------------
Clarice Dennison
------------------------------
- MarkShnier__You3 years agoQrew LegendYou 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
------------------------------- ClariceDennison3 years agoQrew TraineeThanks Mark!
I've created a dummy form.
I'm probaby missing it, but I don't see the Forms menu.
Should I be looking at a different area than the two screen shots below?
------------------------------
Clarice Dennison
------------------------------- MarkShnier__You3 years agoQrew Legend@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
------------------------------