[snip] > Well, one reason could be, for example, that the address changes > over time and they want to know what address the customer was > when the order was processed. [/snip]
So you would delete an old customer address in favor of a new one? I would rather have an 'active/inactive' column with an accompanying date stamp. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]