Is there LPL to "Select Distinct" records when specifying fields in a list view? For example, select distinct company, location, and item on inventory transaction lines instead of every instance? Thank you.
The only use of distinct I'm familiar with in LPL is within a for loop and I don't believe you can apply something like that instance selection for a list.For instance you could...for each distinct Company in InverntoryTransactionRel DO SOMETHING HERE
How about a Select top 1? Instead of all records could we say select only 1?
You can use first
Here is a clip of the list. Where do I put "first" in?
