Get Value of Last Portal Record

[PilatesBlackBelt]

Is there any way to get the value in a field that is the last record in a portal?

 

For example, if this were my portal:

1 - blue

2 - green

3 - silver

4 - purple

 

Is there any way to get "purple" to appear in a field that is outside the portal?

 

And once "5 - orange" is added to the portal, to have "orange" appear in the portal?

 

Thanks!

[devinriley]

Why not add a date created field to the portal table and then sort the relationship on that in descending order. Now if you add just the related field to your layout, you get the last related record created for the one you're browsing.

[David Head]

So you have two tables - Person and Colour - linked by PersonID.

 

To display the last related record value from the Colour::Colour field, use a calculation in the Person table:

 

GetNthRecord ( Colour::Colour ; Count ( Colour::ID ) )

 

If you want the number and a dash to come with it:

 

Count ( FavColour::ID ) & " - " & GetNthRecord ( FavColour::Colour ; Count ( FavColour::ID ) )

 

See how you go with that. smiley_cool

[PilatesBlackBelt]

I used David's method. It worked great! Thanks! smiley-smile