Calculation to determine the last record

[Robert T]

Hello,

I would like to create a field that will 'know' if it is the last record. I have been posting with regard to using a database to generate HTML output for this application I need to know if a record is the last one so I cen generate the appropriate closing HTML tag.

Thanks,

Robert

FileMaker Version: 7

Platform: Mac OS X Panther

[-Queue-]

Create a calculation field equal to Status(CurrentRecordNumber) = Status(CurrentFoundCount). This will return a 1 if it's the last record, otherwise zero.

Oh, and make sure it is unstored, otherwise the status functions will not update.

[Robert T]

Ahh thank you. I actually found a way to do it but it was more complicated than it had to be. I like this way better.

I was using a Summary field called Record_Number that took a running count of field Item_Name. Then I created a Calculation field Record_Number_Calc that was equal to Record_Number so as to make it available for use in another Summary field called Last_Record and defined as Maximum of Record_Number_Calc.

At least I can find back doors for doing things (most of the time, (lolol)

Robert