Re: Imputting 2 types of addresses
Posted by: exkludge gmail
Date: September 28, 2007 08:14PM

hi,

maybe you can create a table similar to this one:

table_address
=============
owner_ID - ID of someone who own's the address
address_type - field to tell if the address is shop/billing/both
address_complete - field to store the actual address, you may further divide this in detail


for the address_type, you may use the following coding:

"SHOP" - means that the current record is the shop address
"BILL" - means that the current record is the billing address
"BOTH" - means that the current record is both shop and billing address

hope this helps :)

Options: ReplyQuote


Subject
Written By
Posted
September 14, 2007 04:27AM
Re: Imputting 2 types of addresses
September 28, 2007 08:14PM
September 29, 2007 03:02PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.