I want to create a report that shows me details from all involved objects.
- The main object is an
account
(Record Type:1
). - Each account is connected to one account (Record Type:
2
) via a
lookup. - each
account
Type 1 can have only oneaccount
Type 2, but one Type 2 can get related to n Type 1 entries - I have a custom object
Timebook
that is connected to a specificaccount
(Type:1
) - each
account
(Type 1) can have severalTimebook
s
Now I want to create a report showing the following:
- a list of all
timebook
entries, with relatedaccount
details from both Type 1 and the related Type 2
I can display the details from timebook
with account
Type 1, but not the details from type 2, like address, mail and such.
I tried to create a joined report
, but cannot add another account
object.
Here is a schema of the involved objects: