Forum Discussion
StanleyGoldberg
Qrew Trainee
Did we get the instructions for the grid edit solution? I am also interested. Thank you!
KateTheriault
6 years agoQrew Cadet
I still don't understand this fully. I have a grid edit for a Cycle that is a many to many with Recipes. When selecting Recipes from a Cycle, I only want "Build" recipes to show up, not all the recipes. However, the record picker shows all 2,000 lower level recipes as well.
I have a report in the Recipes table that filters the top level recipes. And if I embed Recipes in the Cycle Recipe table (the table that connects the many to many), I can select that report and it will filter the Recipes in the form view.
However, I cannot figure out how to make my grid edit, where a user can add as many Cycle Recipes as they want to Cycles. That Recipe field still shows all 2k recipes. How can I select that report for the many-to-many relationship?
Edit: Nevermind, I got it, thanks so much! I didn't understand you had to change the Grid Edit section to the new form.
I have a report in the Recipes table that filters the top level recipes. And if I embed Recipes in the Cycle Recipe table (the table that connects the many to many), I can select that report and it will filter the Recipes in the form view.
However, I cannot figure out how to make my grid edit, where a user can add as many Cycle Recipes as they want to Cycles. That Recipe field still shows all 2k recipes. How can I select that report for the many-to-many relationship?
Edit: Nevermind, I got it, thanks so much! I didn't understand you had to change the Grid Edit section to the new form.