Jump to content
Sign in to follow this  
Mats

Re-make auto enter value

Recommended Posts

I know I found it here before, but I can't fint it now. I have an auto enter value starting at 1 for all my records. Now when I made an import I made a mistake so there where no numers filled in. (blank)

So nu I have a lot of records with no numbers. Can any body help me with a solution?

Share this post


Link to post
Share on other sites

- find all the records with no numbers (go to find mode, put = in the serial number field, find)

- click in the serial number field of the first record

- use 'replace' command (records menu I think) and make it start with whatever the next number is and increment by 1. You can make it update the 'next serial number' value when finished so that future records will be numbered.

To avoid it happening again, make sure the number field has validation on to ensure it's always NOT EMPTY and UNIQUE and the validation is STRICT.

Hope this helps

James

Share this post


Link to post
Share on other sites

I see now that I want to change all the numbers and start all over again fresch.

And also I don't find a "replace" only "find and replace" ? Thta's when I'm in Browse mode.

Share this post


Link to post
Share on other sites

Hi

1) Show all the records

2) While in Browse Mode, put the cursor into that field ( the one where you want to put serial numbers )

3) Make your choise from menu: Records >> Replace field contents...

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

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