Everytime a solution is brought up that has potential for corruption, there is always example of it working fine in the real world for many years. It's up to each person to decide how risk averse they are to choosing a solution with potential corruption.
Tyrone Lumley wrote: > Well, that does raise some issues I guess. However, in all my years ,I > can't recall EVER seeing a duplicate PO from two different customers. > > In Aersospace/Government contracts, each buying party had a different > prefix, and unique POs. > > Later, when I moved into wholesale/apparel, different customers had > different PO structures. > > A good friend, IT Manager of a major telecommunications supplier, uses > the same key. They do about 5000 line items daily, and he hasn't had > any problems. > > Of course, he only has 2 or 3 major customers. And my experience never > exceeded about rwo dozen. All end users and/or retailers. > > I guess if you were selling to the general public or Ma and Pa shops, > and they were using Quick Books or something similair, yeah, it could > happen. > > Again, however, make the key Customer ID + PO...... > > Don't really understand the Pot, Kettle, Black remark *scratches head* > > Michael Mattias <[EMAIL PROTECTED] > <mailto:michael.mattias%40gte.net>> wrote: > > Sounds like the underlying DB was designed poorly. I almost always > make the PO number the primary key. > > Customer #1 sends his PO # 1001 > Customer #2 sends his PO # 1001 > > Kettle, pot, black? > > MCM > > > --------------------------------- > Do you Yahoo!? > Get on board. You're invited to try the new Yahoo! Mail. > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed] ... Please use the following Message Identifiers as your subject prefix: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Job postings are welcome, but for job postings or requests for work: <JOBS> IS REQUIRED in the subject line as a prefix. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/EDI-L/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
