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

Assign a sales order(line item) to a case (Master Detail relationship)



I need help In assigning a sales order to a case. A case can have one or more sales order assigned (as line items).


How can I assign a sales order? The sales order already exists and when assigning I want to add more information, which will be a sales order field.




You can create a new junction object to the case with a Master Detail relationship to Case, and a lookup reltationship to your Sales Order Line Item.  The additional information can be added in custom fields that you create on the junction object.


Thanks. That is my Plan A, but had a though- why create a another object/junction when the record (line item) is alreday available. Just assign it to header, and more data to the line when assigned.


Sure, you could do that too, but if your Sales Order Line Item is already in a M/D relationship (to your Sales Invoice I suppose), then it cannot be on the detail side of another master/detail relationship.