sorting a lookup

[scooter6 at gmail.com]

CentOS Linus and fp 5.6.10R4
I have in my input processing for my operations staff a lookup that looks
at previous letters that have been sent...

The crux of it should lookup to file A using account number in a browse
lookup to show previous letters sent
It does this using index A in file A which is account number....now I need
to find the 'most recent' record in the browse lookup
For now, it will show

  Date                Letter                 Date Req
09/11/11          Letter 1              09/10/11
10/15/11          Letter 2              10/14/11
06/23/12          Letter 3               06/22/12


The way my processing 'should' work is it should find the 'MOST RECENT'
letter (in this case, the one from 06/23/12) and it should capture the date
06/23/12 and compares it to today....if it hasn't been 14 days or more, it
pops up a message saying 'hasn't been 14 days...' blah blah blah
This was written a LONG time ago...apparently, this method only works if
there is ONE record it finds in the above browse and that date is within
the last 14 days
How do I get it to first, find all the records in file A using account
number and THEN have it sort by date?  Should I just create a separate
index that is acct num & date combined? (Assume that's the easy fix here
right?)
Or is there a better/faster way to do this within the code that will 'loop'
thru the records and grab the 'most recent' one

Hope that makes sense
thanks

Scott
PDM
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20120627/f474e5bc/attachment.html