This involves three applications:
1. Job Sites application (master app of realm which connects to all other apps)
2. Inspection application (various inspection forms)
3. Scorecard application (aggregation application which connects to all other apps and pulls in key data for monthly/quarterly/annual reporting)
Job Sites have a one-to-many relationship with tables in Inspections. Job Sites have a one-to-many relationship with tables in the Scorecards.
I?m almost complete building a scorecard application that will pull data via summary fields from multiple applications. I?m trying to find a way to let the user set a period via two date fields in a Scorecard record which can then be used as filters in one of the aforementioned summary field.