Hi,

I'm setting up a new database for our e-commerce site. I'm unsure on what the best approach would be on setting up billto and shipto address data for a customer and for an order. i'm thinking in some cases the customer address may differ in an order. Should the address data be in a separate table (addresses) so that the address_id will be associated with a customer and orders? I'm thinking this may be the best approach. Any thoughts will be appreciated.

thanks