A custom Order object and Order lines are generated via a trigger from the Opportunity and Opportunity Products.
- Opportunity and Order have lookup relations between each other.
- Opportunity Product has a lookup relationship to the Order Line object.
- Order Line object does not have a lookup to the Opportunity Product. When I try to go to the Order Line, click new Lookup field the drop down does not list Opportunity Product/Line item option.
- Order Line object has the Opportunity Product's SFID stored in a text field.
- There is no parent-child relationship between Opportunity and Order .... and no parent-child between Opportunity Product and Order Line.
Ask is to use the above conditions to get Opportunity Product's fields on the Order Line object.(It can be formula field or text field on the Order Line level - Field Type does not matter) How can it be achieved?
Peace & Love