So I have a report that shows incidents at my retail stores; the incidents are auto imported in with the all the incident info, including the location that the incident took place. I'd like for each incident on the report to auto populate that location's manager. I have a table that has each location with the corresponding manager. Just not sure how to link it all together in the report