Imputting 2 types of addresses
Posted by:
Jai Pierce
Date: September 14, 2007 04:27AM
Hi all
I am creating a DB with 2 addresses in it, one is the shop address andc the other is a billing address. How do I create the table that if the billing address is the same as the shop address I use the same details without having to input the data twice. I think I need to create a table for the addresses and then link to them via a key, but I want to have a boolean expression like a tick box that asks if the billing address is the same as the shop address and if so this same data is used for both addresses.
Table "Addresses"
ROW 1 ID
Shop_line-1 VARCHAR
Shop Line_2 .....
Zip_code .....
.....
....
ROW 2 ID
Billing_Line_1 VARCHAR
Billing_Line_2 .....
Zip_Code .....
......
.....
Billing_Same_as_Shop TRUE/FALSE
Thanks for any advice
Jai
www.riot-ink.com
Bringing The Tattoo To You!!!!
Subject
Written By
Posted
Imputting 2 types of addresses
September 14, 2007 04:27AM
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.