Newbies lynxbci Posted January 22, 2009 Newbies Share Posted January 22, 2009 Hi, I have a field where the user currently enters a product code into a text box, made up of 4 letters, and then 3 numbers. I need the 3 number part to be automatically generated. How can i do this? I haven't written a script before, but can easily learn as i have a good knowledge of programming functions in other applications. Or maybe it is a simple text control. Thanks in advance. Link to comment Share on other sites More sharing options...
bcooney Posted January 24, 2009 Share Posted January 24, 2009 This is a calculation problem. Create a new number field, and set its entry options to auto-enter a serial number. Then, you can create a new calc field "dsp_ProductCode" = Product Code & SerialID. Don't use this field as a key. Use the serialID as the primary key. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5567 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