ExpressVP Posted April 3, 2007 Posted April 3, 2007 I'm having trouble figuring out how to have filemaker automatically enter a order number/serial number for each entry. This is the way I'm doing it right now. In database I go to define, create a new name, and select "Number" as type, and under options I select serial number, check "Generate - on creation", and then I want it to start at 2500, and for each entry have it add 1. After I said OK, it doesnt show up and acts like I did nothing to it.
Ender Posted April 3, 2007 Posted April 3, 2007 Newly defined serial numbers only affect subsequently created records. If you wish to number existing records, set the cursor in the serial number field (in Browse Mode), then select Records->Replace... and use the serial number option. This will renumber the records in the found set, so make sure your found set is correct and don't do this without first backing up your file.
Recommended Posts
This topic is 6505 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 accountSign in
Already have an account? Sign in here.
Sign In Now