Calc to show prior record in portal

[AlanP]

Hi everyone,

In one of our portals we have a running list of books issued out (numbered). I'd like to create a 'not returned' letter for the prior book. Is there a way to do a calculation on this?

For example of the portal please see attached. The top record is the most recent issued book, the second is the prior. This will be a recurring thing so the calc must always look at the prior issued book even though there might be tons of prior records.

Hope that made sense! Thanks!

Edited September 6, 2005 by Guest

[-Queue-]

Create a relationship which includes T1::DateIssued > T2::DateIssued and sorts by DateIssued descending. Then T2::BookName refers to the 'prior' book.