Displaying x of x records found

[eddyb2]

Hi

I run a script on a button to perform a find

This finds the records based on the users criteria then takes them to a new layout to display the results.

On this layout i would simply like to add a line of text that says "Displaying X of X records found" just as it does in IWP.

Is there an easy way of doing this or am I looking at using calcualted fields to do this.

I know there are certain symbols you can use on a layout to display username, version, last modified etc I was wondering if the same is true for current record of current found records?

I dont know if this makes a difference but it is a hosted database on FMSA 9 with clients perfoming finds in FMP 9

Many thanks

[aldipalo]

This will work. Make text changes to say what you want.

Create a global field. Set as a calculation. Add the following:

Let([

Fc = Get(FoundCount);

Tc =Get ( RecordNumber )];

"Viewing " & Tc & " of " & Fc) &

" records."

[bcooney]

You need a calc field, result text, unstored:

RecString = Get (foundcount) & " records found out of " & Get (recordcount) & " total records."

You can put this as a merge field in the footer of your list view. I put one of these in each table.

[eddyb2]

I was along the right lines with my calc field - just found the issue was storage - do not store calculate when needed...

Thanks both for your help