T
Thomas Mercer-Hursh
Guest
Point being that with a requirement like that, one can't use an autonumber type field. Moreover, there is always the possibility that someone will enter an order as an internal order and then discover it should have been external. With the GUID (which one never looks at as a user), one can change the order number and all is well. I had a customer years ago who had a system like this for customer numbers ... against my advice. I had to write him a routine that would go through the database and change from old number to new number everywhere it was used whenever they made a mistake.
Continue reading...
Continue reading...