Portal filter for highest values

[Mickster]

I have a portal showing a group of records with the following fields: title, description, serialNo, and versionNo.

I don't want to show all the records though. I am trying to filter this portal to only show the most recent version of each title.

This can be determined by finding all the records sharing the same title and finding the one from that group having the highest versionNo.

Been looking to crack this for hours now! Thanks for your help!

[comment]

Do you also have a table of Titles, where each title is unique record?

It would also help to know what are the two tables involved in the relationship that your existing portal is based upon, and what is the relationship between them.

[Mickster]

I don't have a table for the Titles yet, though this makes sense.

The original table is "Companies" from where I start navigation to various parts of the solution. Anyway, in this case the relationship is Companies::acct x Procedures::gtitle which allows the display of all records in the Procedures table.

I have created another portal that shows those records with checkbox for RevisionNeeded.

[comment]

Well, if you had a table of Titles, you could create another relationship chain like:

Companies -x- Titles 2 -< Procedures 2

with records from Procedures 2 sorted by version, descending.

A portal from Companies to Titles 2, showing fields from Procedures 2, would show the most recent procedure for each title.

[Mickster]

Hey Carpal Tunnel,

I played with this and after a while I got this to work:

Companies --x--Titles --=--Procedures

A portal Titles shows 1 field "Title". From that point I only sorted the portal with Titles:modstand for in descending so the latest mod'd Procedure shows up at the top. So far, so good.

Thanks again.