Jump to content

Re-make auto enter value


This topic is 6190 days old. Please don't post here. Open a new topic instead.

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?

Link to comment
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

Link to comment
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...

Link to comment
Share on other sites

This topic is 6190 days old. Please don't post here. Open a new topic instead.

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
×
×
  • Create New...

Important Information

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