last
tell app "FileMaker Pro" to get last record (* returns a list containing the values from the last record in the currently active database *)
last returns the last item in a container, such as
files in folders, records in databases, or cells in records. You must
test the return result, however, because the ordering scheme to
determine which object is last may differ depending on the container.
In folders, the last item may be the farthest back in alphabetical
order. In a database, the last cell is usually the last column in a
database schema or layout. last, when used in the
manner of last record or last file, is a synonym of back.