ProdigyOne2k
asked on
Managing "ShipTo" address in database
I have an "address" table with...
addressID
addressLine1
addressLine2
city
state
zip
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?
addressID
addressLine1
addressLine2
city
state
zip
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I agree with dale. I would add this to the shipping document or order as notes or shipping instructions.
<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.
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.