using globals to filter a portal
I am building a solution based of a simple checkbook register table. I was thinking about using it to track payments to vendors and using a portal set up to filter the transactions to make a simple report with easy to modify set up.
Would it work to have the portal relationship based on a Global::VendorID to register::VendorID relationship, then filter the portal to display Global::StartDate > register::Transdate > Global::EndDate
Then put a summary field below the portal to give the total of the amounts in the portal?