Does anyone know if I can make something like this:
1. I have some service orders that have two rows for instance:
Client Order
Supplier Order
Supplier
Product Sold (Output Needed)
Sale Order 1
Buy Order 1
Supplier n
Ocean
Sale Order 1
Buy Order 2
Supplier z
Ocean
I need to manually create a field called 'Product Sold' that would be like this
if(Supplier= 'Supplier z', 'AIR','OCEAN') as Product Sold
My problem is that, since I have two suppliers and my trigger to assign the product category will always be the final supplier but in the data model they are not always in the correct order, when I use the conditional it always uses the first row it finds so result is not always accurate.
Can any one think in a better solution to make the propper product category allocation?
