> OK, let's use a synthetic key on the sales master table. In fact, > *both* companies have a synthetic key on their sales master tables. > > OMG, conflicting/overlapping synthetic keys!!!!! Which are not exposed in any UI and therefore easier to change? Heck, I'd use UUIDs everywhere if it weren't such a pain in the neck to type them into queries. -- Scott Ribe scott_ribe@xxxxxxxxxxxxxxx http://www.killerbytes.com/ (303) 722-0567 voice
