Jump to content

Serial number counter

This topic is 5713 days old. Please don't post here. Open a new topic instead.

Recommended Posts

A customer decides what items they want. From a customer database a new job ticket is created and all of the items this customer wants are entered via a portal. As the items are entered, fields in the portal are populated with information from another database about the item such as price, color, size and category. The category may be wood, metal, plastic, glass, or paper. The order that the items are entered is critical for assembly at a later date. None of the categories are really important except for the paper one. What I need is a (auto entry) counter so that everytime paper is the category a (field named paperpostion) would populate with it's position (starting with 1) and increase by 1 everytime paper was the category. Like this

item category paperposition



paper 1

paper 2



paper 3

The next customer decides the items they want and if paper is one of them, their first paper item would get a number 1 and so on.

A solution that seems so simple eludes me. Any help is greatly appreciated.

Link to comment
Share on other sites

This topic is 5713 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 account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.