I know that you should not attach meaning to an auto-number field as its only role is to be unique but would it go against common practices to use it as a sort of "job number"?
What I mean is when say a project in the database is created, you would use the auto-number to say that it is project # (insert auto-number here) just to identify it within the database. Is this bad practice and should I create my own system for something like this? Bear in mind, I am not using this like say a quote number, just an identifier within the database itself.
What I mean is when say a project in the database is created, you would use the auto-number to say that it is project # (insert auto-number here) just to identify it within the database. Is this bad practice and should I create my own system for something like this? Bear in mind, I am not using this like say a quote number, just an identifier within the database itself.