I have one Parent table for Invoices and a child table for Line Items.
I'd like to be able to dynamically filter a portal comprised of the child items by entering data into an array of global Invoice fields.
For example, by typing "Acme, Inc." and "Morris Chestnut" and "Paid" into globals labeled "Customer Company," "Sales Exec" and "Invoice Payment Status" respectively, I'd like to see the portal change accordingly.
I've search for the solution, but have come up short: Susan Severson's article doesn't seem to be exactly what I'm looking for, brilliant as it is (see http://www.soliantconsulting.com/blog/2013/03/dynamically-filtering-filtered-portals ).
Is this possible to do with multiple global fields on a relationship level without including scripting or bogging down the system?