I've tried an external file holding serial numbers, but I'm not too comfortable with that concept. All other serial # have been converted to ###### - ####### - ###### format based on time, record number and date, but this is too long for our inventory numbers that are hand written on 1/2" tags.

Is there a way to use the auto increment serial number and update it with a script on solution version update?

Hi there,

Its no problem.

First make a globan field named "Version global".

Make another field "Version".

Make a script which run automatic every time you print or close the db:

Set "Version global" with Version.

Set "Version" with "Version global" + 1

Make a calculation field:

Serial number & " - " & Version & "."

This give the result: #### - ##.

Good luck!

-Per

You are better off using a simple sequential serial number for the human readable display (i.e. shown on the screen, printed on labels) and use the other ID number for relationships and program controls, but NEVER, EVER reveal it to the user or allow them any access to it.

This allows you to do ANYTHING that you want with the human readable version, and not have any effect whatsoever on the real ID that is being used programatically.