Finding the last record in a recordset.

[Amorra7]

Greetings,

I was just wondering if there is a "Find Last Record" script in Filemaker 7? I need to be able to copy information from the last record in one table to a new record in another table?

Thank you so much!

[color:"red"] A.

[Tripod]

Use status(CurrentRecordCount) or /(foundcount), depending on what you want to load, to set a global in the file in question. Then, you can access that number in a script and, within scriptmaker, you can use the 'Go to Record/Request/Page' command to go to that record by number, or field value.

[Fenton]

How about Go to Record [ Last ]? Be on a layout for that table.

How are you "setting" the data into the other table.

[Tripod]

That'd work!

If you used my , er, 'um "approach," you could at least maintain a variable that would be accessible via a relationship.

[searanger]

If you want this to work via web browser I used a calculated field.

I also could not get count(field) to work and update.

lastrec.zip