An embedded report would be of use, but the end goal is to be able to create reports that can summarize and cross-reference data between the two tables, which can then roll up to other reports.
I'm actually trying to aggregate data between this report and several others, I just started with the Vehicle Assignments table because it is already connected to those other reports and is likely to be able to function as a pass through once I can get the Driving Event record to "see" the Vehicle Assignment that corresponds based on the date parameters and Vehicle #.
The end goal is that I could create reports to summarize the driving behavior by Vehicle or by Driver, bounded by the Vehicle Assignment that is in place at the time of the activity. The relationships between Vehicle, Driver, and Vehicle Assignment tables are well-established and I can easily pull data up/down between those tables and into reports that combine info from these records.
What I'm struggling with at the moment is that the Driving Event data is coming from an external CSV report and is therefore not "hooked in" to any of these existing tables. I have fields that I can match up between these reports and existing tables, namely Driver ID and Vehicle #, but they are not "connected" to any other tables because they are just text that is being pulled in from this report. I'm trying to find a way to relate this info to the other tables that will allow me to being pulling information between them in ways that will enable data analysis.
------------------------------
Amy Christensen
------------------------------
