function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Matt FolgerMatt Folger 

To Relate or not to Relate these objects?

I will be doing a daily import of Orders from our ERP system.  This data is structured in two part schema: Order_Header and Order_Detail.   I am debating on associating any type of Lookup or Master-Detail relationship between these two sources in Salesforce.  I do not need to enforce data validation/coherence between these two objects on the Salesforce side, as the data is read-only and mono-directional from the ERP into Salesforce.  Even though I don't need the data quality/integrity that this relationship provides, I need to restructure the data on the Salesforce side much like it is in the schema of the source/ERP system.  That means a Parent-Child (or in Salesforce's lingo Master Detail relationship).  If I do not set up this type of relationship between these objects, I'm not sure what type of limitations this will do to me when I'm trying to use Reports and Dashboards in creating Reports around these specific objects.