Hi,
"Product" and "Order Product" are two different entities.
"Product" contains all the products registered in your CRM, "Order Product" store the lines of an order containing an existing product or a write-in product.
For example in your CRM you have five products: Product A, Product B, Product C, Product D, Product E.
You create an order for a customer, where you sell to him Product A, Product C and a custom maintenance service.
You will add to the Order 3 "Order Product", 2 of these "Order Product" will contain a lookup (reference) to the "Product" entity (for Product A and Product C) the third "Order Product" will be a "write-in"
product with a custom description as "custom maintenance service".
My blog: www.crmanswers.net -
Rockstar 365 Profile