I have a requirement to query multiple price lists and then compare them and select the lowest price. Once I get the price, I need to report which price list it came from and the price. If all prices return zero, I also need to report that.
I can do all of the above with a lot of Run-If controls. I am trying to prevent that. I would like to use a collection for the returned price but I lose the association between the price and the price list. Has anyone come up with a better way of doing this than using lots of run-ifs?
Thanks