Apex Code Development You need to sign in to do that
Don't have an account?
Join 2 custom objects and a standard one without lookup fields
Hi,
I have 2 custom Object with the following structure :
#Book
Id
BookId
BookName
#BookBought
Id
BookId
UserId
User Id reference a contact field under contact name UserId (Not the salesforce Id)
I want to create a report that joins these 3 objects : Book, BookBought, and Contacts without using any lookup fields
Is this doable please ?
Thanks
I have 2 custom Object with the following structure :
#Book
Id
BookId
BookName
#BookBought
Id
BookId
UserId
User Id reference a contact field under contact name UserId (Not the salesforce Id)
I want to create a report that joins these 3 objects : Book, BookBought, and Contacts without using any lookup fields
Is this doable please ?
Thanks
To run the report, you need to have relations, if only report will able to fetch the data.
All Answers
Picklist can work. If you do not want the relationship between this objects.
On Book object 'BookId' as picklist of "BookBought". And on BookBought 'userId' as picklist for Contact.
I am not sure how this will help you to achieve your Goal.
Thanks
Aniket
If you think answer has solved you query , please mark this as ANSWERED
Thank you for your reply
I wanted to check if running a report of three objects that are related without Lookup is possible ?
They are related via ids but not salefsorce ids, does it make sense ?
Example:
#Contact
Id Salesforce Id
UserId 25
#Book
Id Salesforce Id
BookId 12
BookName Book1
#BookBought
Id Salesforce Id
BookId 12
UserId 25
Thanks
To run the report, you need to have relations, if only report will able to fetch the data.