Last Occurrence Type question
I am looking to get the latest product code based on two identifiers, one is called BVFSKU and the other is Vintage:
Module one is called Latest FERT - module to pull the data in to and based on the BVFSKU list
Module two is called Masterdata - module containing all of the data needed and based on a list called masterdata.
So what I would like to do is lookup the BVFSKU in the Masterdata module and find the product codes that match this criteria but then also return the latest product code. The masterdata list is a numbered list so that could provide the latest entry, but we use a display field so we can't see this number
Hoping someone can help