Jump to content
Sign in to follow this  
raymate

adding numbers into a databse automatic

Recommended Posts

Have an old FM file that has 880 records in it, we have added a serial number field and asked it to start counting from 881 and this is does with any new records.

What we would like it to be able to put the serial number into the old records, of course old records have nothing in the serial field.

Apart from typing in 1-880 into every record, could it be done some how I assume changing the field from a serial to something else, add the numbers then turning back on the serial number option.

R

Share this post


Link to post
Share on other sites

Show all records (Cmd J)

put your cursor in the serial number field

Main Menu >> Records >> Replace Field Contents

You will get a Dialog Box

Second Choice Serial Numbers. Put [color:red]1 in the first field, Click [color:red]Replace

HTH

Lee

Share this post


Link to post
Share on other sites

OMG, that was so easy... never thought to look there, I was dreaming up some sort of calc to do it...

Thank you..... :)

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  

  • Who Viewed the Topic

    1 member has viewed this topic:
    ash1474 
×

Important Information

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