So I think Mark's suggestion will work. I was hoping there might be a more efficient way, but likely not.
Example for Everett.
We interact with 7 different reps at Energy Supplier A.
Rep 1 handles electricity in MA
Rep 2 handles electricity in NY
Rep 3 handles natural gas in MA
Rep 4 handles electricity and natural gas in MA
Rep 5 handles fuel oil in MA
Without getting into some real confusing aspects of our process, I want to summarize on the supplier record the reps that handle various combinations of territory and commodity. So conceptually Marks approach works, although I need to think about the combinations to determine if it is practical.
Thank you.
