Determine if the description is Master/Detail or Lookup

Master/Detail.

When creating a relationship between two objects in Salesforce, you can either create a Master-Detail relationship or a Lookup relationship. Both relationship types allow you to create a field on a child object that displays data from a parent object, but there are some key differences between the two.

In a Master-Detail relationship, the child object is known as the detail object, and the parent object is known as the master object. When you create a Master-Detail relationship, you create a field on the child object that references the parent object. The child object field that references the parent object is known as the Master-Detail field.

Master-Detail relationships have several characteristics that make them unique. Firstly, they are required relationships, meaning that a record cannot be created on the child object without a corresponding record on the parent object. Secondly, they have a cascading delete behavior, meaning that if you delete a record on the parent object, all related records on the child object will also be deleted. Finally, in a Master-Detail relationship, you can roll up summary information from the child records to the parent record.

In a Lookup relationship, the child object has a field that references the parent object, but the relationship between the two objects is not as tightly coupled as in a Master-Detail relationship. Unlike Master-Detail relationships, Lookup relationships are not required, and you can create a record on the child object without a corresponding record on the parent object. Additionally, deleting a record on the parent object does not delete related records on the child object.

In conclusion, when you need to report on parent and child fields, you need to determine if the relationship is a Master-Detail or a Lookup relationship. Master-Detail relationships allow you to roll up summary information from the child records to the parent record, which can be useful for reporting. However, Lookup relationships may also be useful for reporting, depending on your specific use case.