Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Rahma__cRahma__c 

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



 
Best Answer chosen by Rahma__c
Aniket Malvankar 10Aniket Malvankar 10
Hello Rahma,

To run the report, you need to have relations, if only report will able to fetch the data.

All Answers

Aniket Malvankar 10Aniket Malvankar 10
Hello Raham,

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
 
Rahma__cRahma__c
Hi Anlket,
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
Aniket Malvankar 10Aniket Malvankar 10
Hello Rahma,

To run the report, you need to have relations, if only report will able to fetch the data.
This was selected as the best answer