show only last record

[bens]

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?

[sbg2]

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

[bens]

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

[Raybaudi]

So ?

sortMOD.zip

[bens]

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

[comment]

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.

[Raybaudi]

...and so ?

sortMOD2.zip

[bens]

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.

[comment]

See if this helps.

SecondLast.fp7.zip

[bens]

:thankyou: both