Sequential Part Number Generator...with a twist

[Chris Gassett]

The users would like a sequentially generated field.  The field is split
into two sections  XXXXX-XXX (Ex.   000012, 000013-001, 000014, 000014-001,
etc.)  and is handled with three variables.  The first 5 characters is the
field that is generated sequentially.  In entry mode the user would hit the
enter key and the next number would be generated automatically and the
cursor would move to the last three digits and the dash in between would be
displayed or the user can enter up to 5 digits of a previous record to
append to the end of it with three additional characters.  The user has the
option to enter up to three characters or hit the enter key.  If the enter
key is pressed without entering data the dash disappears and the second
field is left blank.  My problem is if two people are accesssing this screen
at one time two or more users can grab the same sequentially generated
number.  What I need to do is do commit the record after the second field of
three characters is passed.  If anyone knows of something remotely close to
what I am attempting to do I would greatly appreciate the feedback.  Thanks,
Chris
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.