AnsweredAssumed Answered

using globals to filter a portal

Question asked by mgores on Oct 28, 2011
Latest reply on Oct 28, 2011 by philmodjunk


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?