GetNthRecord question

[Robert Collins]

I am trying to look up a value of a related record

but am having some trouble.

The relationship between the two tables is a phone

number and one of the tables holds multiple records with this telephone number. I would like to obtain a fields contents from the last record oof this table. I thought about using the getNthrecord function but this requires knowing the record number so what I need is something like this

GetNthRecord (field ; lastrecord)

is there a way of Getting the last related record for this to work?

thanks

[comment]

Well,

GetNthRecord ( related::field ; Count ( related::phone ) )

could do it, but

Last ( related::field )

would be a lot simpler. Note that they are not exactly the same, and you will see a difference if the last related record's field is empty.

See also:

http://fmforums.com/forum/showtopic.php?tid/198224/post/303896/#303896

[Robert Collins]

thanks for that