> 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 [EMAIL PROTECTED] http://www.killerbytes.com/ (303) 722-0567 voice ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
