Posted Wed, 04 Aug 2021 21:32:05 GMT by

I have multiple records in a view.    What is needed is only record per order number.   Each order number goes into multiple sales orders.   They want to see only one record per order and the sales information of the earliest order. In Excel you sort it by order number and sales due date.  Then you run remove duplicates and it leaves the first one it comes to and deletes the rest.  Is there an easy way in Sequel to do this also?

Posted Tue, 24 Aug 2021 03:35:15 GMT by

yes.  build the view as needed.  set the sort on the order ascending and the date in descending order.  select file/properties and set the unique key to 1.

You must be signed in to post in this forum.