Thanks for all the responses! The one from Grigoriy was particularly
interesting, I hadn't thought of that approach.
However, I came to the realization that if somebody changes their address, I
don't want it to be changed on previous orders. So I think i'll change the
orders table to contain the actual address information and use an INSERT ...
SELECT instead. That way I can be sure I have an accurate record of all
orders.
Thanks!
- James