Record Count

[redballoon]

I have a database where the user logs in and can then brows through their own records, these records are brought up by a search when they log in.

I can display the number of records found... i.e. their records but cannot find a way to show a live count so each record they click through show's record 1, 2 3 etc so they can see how many there are and which one they are on in relation to the total records.

Without the Status area (which I do not want for ordinary users) how do I do this is it a simple Get and a calculation ??

[bcooney]

Add an unstored calc field to the table Found_uc = Get (foundcount), and put on your layout. Simply type "@@" without the quotes on the record to have FM put the "number" of the record.

So, you could have, "Record @@ of <> Records" on your layout. <> is a merge field.

Edited January 20, 2008 by Guest

[redballoon]

Thanks,

I tried the field as you suggested and used Get (RecordNumber)

which seems to do the trick, at least it does at the moment which is great....

[bcooney]

Get (RecordNumber)? I didn't mention that. OK, I guess.