All the master files should have a key rather than using the Customer Number, Vendor Number, Item Number, etc. as the identifier the same way MAS500 does.
The current identifiers should simply be non-duplicated fields.
Using this method to identify the records makes renumber customers, vendors, and inventory items simple because you are not actually changing the actual record key.
by: John R. | over a year ago | General Enhancements
Comments
This would be the smart way to do it. It would make our lives alot eaiser reagarding renumbering anything. MAS500 does it this way it should be done for MAS90!!!!
I completely agree; using a true master key or primary key is the best practice for any database. It would also make integrations with 3rd-party databases (like for a website) much easier, since changes to customer numbers or items numbers wouldn't have to be handled manually, which is very time-consuming!