Managing "ShipTo" address in database

I have an "address" table with...


On every order we have there is an "Attn: John Doe" Or "PO#123456" - something extra on the ship to which makes them almost always different.  I don't want to create a new "addressID" for every shipment, so what is the best way to handle this?
Who is Participating?
Dale BurrellConnect With a Mentor DirectorCommented:
That sounds more like a field on the Order, shipping notes or similar.
Brian CroweDatabase AdministratorCommented:
I agree with dale.  I would add this to the shipping document or order as notes or shipping instructions.
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
<Not sure if this helps, but I'll throw it out there>

A PO box number would be needed by the mail carriers, and should be with the other parts of the address.

Perhaps the order table should be the 'one' table to the shipping_address 'many'.

Especially for the gift-giving season where customers buy presents for people a couple of states away.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.