You can write a quick script that sorts the records by your key field, then sort by date descending. Next make it loop through and omit the duplicate records taht do not have the most recent date.
Since you are on an older version, you will need to use global fields to keep track of your previous record's date.
P.S. Ideally, you will want to have each order be its own record with line items that reference the products, qty, etc.
Thanks for the suggestion, mr_vodka...perhaps a screwdriver would do me well too. :) I will test it out and respond with the result!
PS - Each order is it's own record with it's own pertinent information. My company manufactures vitamins, and this db archives the print shop's label requests on a daily basis. Each label request is its own order.
Thank you much! Works like a charm! :)
I will note for others: You must only perform the "go to next record" step when you do NOT omit a record. Otherwise, you'll skip records entirely. Dunno if this tricky snafu is the same for newer versions, but it hung me up for a bit.