> insert a new address, and update the users table to the new address_id Which changes the user's "primary key". My point was that having the address id be part of the primary key is wrong. Having it be a part of a key may be fine for many uses. But it's contrary to the notion of primary key that something that not only can, but will, change for many records should be part of the primary key. "Unique" and "primary" are *not* synonyms. -- Scott Ribe scott_ribe@xxxxxxxxxxxxxxx http://www.killerbytes.com/ (303) 722-0567 voice
