Need help with FEU logic

[newagekat]

Hi:

I'm currently running CMSMS v1.12 along with latest FEU, custom content, and User Directory.

I need some suggestion on how to organize my groups and properties with FEU mod. Here’s what needs to happen:

The client has Territory Managers or TM in charge of Dealers within their assigned territory.
Each territory is made up of one or more regions
A region may appear in more than one territory
A Dealer can only belong to one region and one territory

What I need to do is
for each logged in TM, list all dealers that match the TM’s territory and sort them by regions.
list activity for each dealer in the TM’s territory, by province

Is this doable? If so, how?

Currently I have 2 groups: TM, Dealers
I created Territory dropdown property and a Multi-select dropdown region property.

I don’t know how to list all dealers within the TM’s territory. Any suggestions? Should the territories be groups?

I usually don't have have any problem with logic, but i can't seem to wrap my brain around this one?

All constructive help is much appreciated.

[JohnnyB]

I wonder if the Company Directory module can give you what you need because it has some frontend user integration. Each item inside of Company Directory can correspond to a Dealer and then maybe you can assign them to TM's that way...