I have a portal that show records (orders) related to a unique id field.

The portal shows the ordre number, creating date and what has been done with the order.

The portal can be many "records" long, what i need is it to show only the 2. last record fixed by date.

Anyone who have any ideas?

Set the portal to show only two rows, sort descending by date and don't check the box for "show vertical scroll bar".

Thanks for the quick answer.

I can't do it like that, because sometimes there is more than 2 orders in the portal, i need a field that only shows the last ordernumber in the "row"

I have attached a file to show how it is made.

sort.fp7.zip

So ?

sortMOD.zip

Thanks Raybaudi

I Think i haven't maked my self very clear.

What i need is not the last but the second last.

In the ordernumber 2524260 it's ment to show 2524259

In the ordernumber 2524259 it's ment to show 2524258

I don't understand your file - shouldn't there be TWO tables? Say, Orders and History, related on OrderID?

In any case, you can get information from the last but one related record by a calculation of:

GetNthRecord ( SomeField ; Count ( RelatedTable::MatchField ) - 1 )

If you select the primary key of RelatedTable as SomeField, you can base a new relationship on the result.

...and so ?

sortMOD2.zip

I don't understand your file - shouldn't there be TWO tables? Say, Orders and History, related on OrderID?

yes

In any case, you can get information from the last but one related record by a calculation of:

GetNthRecord ( SomeField ; Count ( RelatedTable::MatchField ) - 1 )

If you select the primary key of RelatedTable as SomeField, you can base a new relationship on the result.

i don't understand, it won't work for my.

i need it to always show only the last ordernumber, related on order id.

See if this helps.

SecondLast.fp7.zip

:thankyou: both