Magazine article from our research archive:

Questions & Answers

(ProQuest: ... denotes formula omitted.)

Get help from the pros

Q: I use a disconnected architecture in which sales agents take their systems to the field and add new customers. How can I create unique primary keys that are easy for customers to use? We have a few thousand customers, so an integer (rather than a GUID) would be best and easiest for the agents. However, I want to leave a printed invoice with customers that shows their real customer numbers.

A: I suggest using the "sales book" technique for this architecture. That is, the salesperson is given a preprinted set of invoices that include the unique primary key value. Back in the office these values can be scanned into the system. ...

Related newspaper, magazine, and journal articles:

See all results. Or, try our Advanced Search.

Newsweek Harper's Magazine The Washington Post Chicago Tribune Crain's Chicago Business PRNewswire Pediatric News The Nation Advertising Age The Economist (US) A FREE trial gives you access to over 60 million articles! Access over 3,500 publications with a FREE trial!