I have a project where each new record needs a message number automatically generated , increments by one, and does not allow duplicates. I favor using the DMax method while others advocate the autonumber method because that is what they have always used.
How can I best argue the point that DMax is the best method to accomplish this? What are the bad points of using autonumber as a visible, unique, reference # for a record (EX: Work order #, Invoice #, Message #)?
How can I best argue the point that DMax is the best method to accomplish this? What are the bad points of using autonumber as a visible, unique, reference # for a record (EX: Work order #, Invoice #, Message #)?