Find and sort at same time

[graemeaustin]

Inside an inlineaction tag, I want to find a match for a field called 'userid' and then sort the result in descending order by field 'recid'.

Userid is a user name ( which I'm trying to dedupe) and recid is a field containing the record's unique ID.

My problem is that I can't get it to work - all that happens is that the find aspect works but the sort does not appear to happen.

Here is the code I've been using:

[FMP-InlineAction: -db={CurrentDatabase}, userid={fmp-field: userid}, -sortfield=recid, -sortorder=descend, -find]

on]

Any/all help gratefully appreciated.

Graeme

[graemeaustin]

Whatever my problem was I have solved it by using a workaround of a calculation field to highlight the duplicate records thereby saving me losing the current recID.

This dispensed with the need for the inlineaction tag and its associated difficulties.

If anyone wants a more complete solution let me know.

Also I later realised the reason the code wasn't working was because the sortfield is called recordID, not recID. Doh!

Graeme

[ October 18, 2001: Message edited by: graemeaustin ]