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

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.

Guest
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.