Help with relationships?

[l4k3y]

Hi,

I was wondering whether anyone may be able to help with getting relationships set up for my entities.

I have the following entities.

Locations
Events
Fundraisers

Each location can have multiple events which have multiple fundraisers. Fundraisers can only be assigned to one event.

I have set up my relationships and have updated my layouts to show the relationships, however on my locations layout detail, Id like to display all the fundraisers that are linked through the event. Currently I am only able to display the events thatare assigned to the location?

Is there anyway to achieve this?

[rabii]

You need to add another relationship as location have multiple fundraisers and then use formula to set up the locationId on the fundraiser when linked with the event. Keep in mind that this will be a mixture of all fundraisers as your location has many events and each event has many fundraisers, so the fundraisers will be total of all from events linked to current location.