kenseye Posted November 21, 2001 Share Posted November 21, 2001 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? Link to comment Share on other sites More sharing options...
per Posted December 23, 2001 Share Posted December 23, 2001 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 Link to comment Share on other sites More sharing options...
Kurt Knippel Posted December 24, 2001 Share Posted December 24, 2001 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8157 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