Jump to content
Sign in to follow this  

Message field

Recommended Posts

Hi all,

I created a calc field to display the current record number of a found set.

I would like to use it on a layout to tell users what record they are browsing thru (kinda like the status area in FM).

Works just fine except when i sort in a different order or perform a find.

Then it display things like: Record 64 of 7 found or the numbers are not in sequence. I could be looking at record 4 then next record would display as 7 then 5 etc.

What am i doing wrong??

Thanks for your help.


Share this post

Link to post
Share on other sites

Your calc field is showing the record number in the context of the whole file, not the found set. What is the actual calculation you're using?

I've encountered this myself, and I end up having to use scripts to set field values rather than a calc (as in, put down a button for Next Record, but have it call a script that both moves ahead and resets the Current_Record field). But I'm going to lurk on this thread and see what more experienced users do.

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.