field that summates from search

Discussion created by markmueller on Jan 20, 2017
Latest reply on Jan 20, 2017 by philmodjunk

Has anyone made a field that adds numbers from a searched set of another field in a different table? In this case I want the field to show a dollar total of active projects for a particular agency in the agency table. So the search would be based on the agency that is displayed in the current layout/table and would sum dollar amounts from a list of projects from that agency that are active by searching for "active" in a field in a different table. The project dollar amount and the "active" fields are in the other table. The tables are related by the agency abreviation.