All you need is a serial number field, running consecutively for ALL records. Then you can calculate the box by =
Ceiling ( SerialID / 100 )
and the position by =
Mod ( SerialID - 1 ; 100 ) + 1
(assuming serial numbers starting from 1)
I'm very new to FileMaker and I can't figure out how to create a field that will generate serial numnbers for all of the records that are already in the database. I can get it to insert serial numbers for new records but not existing records. Please advise. Thanks!!
Show all records.
Sort your records (if necessary).
Place your cursor in the serial number field and select Replace Field Contents from the Records menu.
Use the Serial number option and this will put a serial number into all your existing records. Select Update serial number in entry options so that your next serial value for this setting will be the next number in the series.
Phil you are FANTASTIC!! Thank you so very much!! I wish I could buy you a drink in thanks!
Here's a virtual toast to my new best friend Phil!!!
Comment's suggestion was the major part of what you needed. I just added a little pointer to get you over the last little hump. :smileywink:
Hey, Phil, I wouldn't sort the records first. They should (I believe) be serialized in their natural sort order of creation (how they are added into the table). If sorted before serializing, later those serials will never look right. Just a thought.
Good point. There's a lot we don't know about this database and the correct order for how they should be serialized is one of them. The unsorted creation order is by far the best guess here.
That's why I added the caveat: "If necessary".