RickPutnam
3 years agoQrew Cadet
Custom Report Link question
I have an Accounts Payable app that maps Invoices to Purchase Orders. A purchase order may be referenced by several invoices so I have a relationship between Purchase Orders as parent and Invoices as child. On the Invoices form, I want to display a report showing any other invoices that reference this invoice's purchase order.
To achieve this, I created a report link that relates invoices by the purchase order. So far so good. Now I'd like to filter the current invoice -- where the report is displayed -- from the report.
For example: Invoices 123, 456, and 789 all reference PO ABC. On the form displaying Invoice 123, I'd like the report link to display only invoices 456 and 789.
Thanks in advance for your assistance with this.
------------------------------
Rick Putnam
------------------------------
To achieve this, I created a report link that relates invoices by the purchase order. So far so good. Now I'd like to filter the current invoice -- where the report is displayed -- from the report.
For example: Invoices 123, 456, and 789 all reference PO ABC. On the form displaying Invoice 123, I'd like the report link to display only invoices 456 and 789.
Thanks in advance for your assistance with this.
------------------------------
Rick Putnam
------------------------------