Reports Help... Reporting on Relationships

I’ve got a situation where I have an account, then I create a one to many relationship “Distributor” I want to use this simlar to the default parent account relationship where I have an account that is a distributor for many accounts.

Now I want to report on contacts and output the Distributor for that contact in reports. I just can’t seem to get it.

(I need to do it from the Contacts module because I want to use this to create a target list)

I can’t understant whay this isn’t working , any ideas?

Nevermind, just got it. Always happens, the moment I give up and ask for help, the answer suddenly appears!

If anyone else comes accross this maybe it can help them:

1 Like