Hello,

i was wondering if someone can help me out with this, i bet it is easy one. i am trying to find the latest record of person base on the date it was create it. it is appointment db, client has more than two record and i want to show up only the latest record base on the date the record was create. i am funning fm 6.0. i want to set up script basically and have button they can click to do the find.

Thank you,

victor

FMP stores records in creation order. So find the preson, unsort & go to last record.

If you're doing a find, the records will naturally be unsorted. So only a find and go to last record is necessary.

How can i do this by a script? so that i can assign to a button?

Thank you,

Victor

Enter Find Mode [Pause]

Perform Find [ ]

If [status(CurrentFoundCount) > 1]

Go to Record/Request/Page [Last]

End If

The pause allows a user to enter the id or name for the desired person.

Pooh-Bah,

Thank you, it work like a charm. i am not good at scripting.

thanks,

Victor