RubyKapil2
8 years agoQrew Captain
Create a report link on a form that automatically filters report based on the value in a field on the same form
I want to add a Link on a form - not sure how to do that but larger problem is I have no idea how to tell Report to look at this field on the current form and run a report based on or filtered on that value.
Table Poles and Table Permits, both use an Application # that lives on Applications Table. Poles is related to Applications via this Appl# and Permits is related to Applications via this Appl#. Many Poles can have this same Appl#. If I'm on the Permits record and I want to display all Poles with this same Appl# without user typing anything, just the database looking at the value of the Appl# on the current form and ideally embedding a report displaying all Poles that match the Appl# or at least opening a report that filtered on the value of Appl# on the current form.
Table Poles and Table Permits, both use an Application # that lives on Applications Table. Poles is related to Applications via this Appl# and Permits is related to Applications via this Appl#. Many Poles can have this same Appl#. If I'm on the Permits record and I want to display all Poles with this same Appl# without user typing anything, just the database looking at the value of the Appl# on the current form and ideally embedding a report displaying all Poles that match the Appl# or at least opening a report that filtered on the value of Appl# on the current form.