How to store multiple mailing addresses

[Jay Villa]

I want to store multiple mailaddress like home address and shipping address
Sometimes addresses will be more than two. I am thinking about storing the
details as a dictionary object. Any other suggestions.

Thanks
Jay

[Tim Williams]

Store where, for how long and for what purpose ?

Tim

--
Tim Williams
Palo Alto, CA
"Jay Villa" <ja******@commu nity.nospam> wrote in message
news:u2******** ******@TK2MSFTN GP12.phx.gbl...

I want to store multiple mailaddress like home address and shipping address Sometimes addresses will be more than two. I am thinking about storing the details as a dictionary object. Any other suggestions.

Thanks
Jay

[Ray Costanzo [MVP]]

Storing them where? Typically, data is stored in a database, but if you're
talking about dictionary objects, can you put this in context?

Ray at work

"Jay Villa" <ja******@commu nity.nospam> wrote in message
news:u2******** ******@TK2MSFTN GP12.phx.gbl...

I want to store multiple mailaddress like home address and shipping address Sometimes addresses will be more than two. I am thinking about storing the details as a dictionary object. Any other suggestions.

Thanks
Jay

[Jay Villa]

When I said storing it means, I have asp pages where users will be enter
multiple address on the screen, I have to gather the data(addresses) from
the asp page and finally i should update the database. Hope I am making
sense ....

Any suggestions. Hope I am making clear .....
"Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
message news:ef******** ******@TK2MSFTN GP15.phx.gbl...

Storing them where? Typically, data is stored in a database, but if
you're
talking about dictionary objects, can you put this in context?

Ray at work

"Jay Villa" <ja******@commu nity.nospam> wrote in message
news:u2******** ******@TK2MSFTN GP12.phx.gbl...

I want to store multiple mailaddress like home address and shipping

address

Sometimes addresses will be more than two. I am thinking about storing

the

details as a dictionary object. Any other suggestions.

Thanks
Jay

[Curt_C [MVP]]

Jay Villa wrote:

When I said storing it means, I have asp pages where users will be enter
multiple address on the screen, I have to gather the data(addresses) from
the asp page and finally i should update the database. Hope I am making
sense ....

Any suggestions. Hope I am making clear .....

So just create the blanks and gather the info like normal. I guess I'm
failing to see where the difficulty is, specific to gathering multiple
addresses?

--
Curt Christianson
site: http://www.darkfalz.com
blog: http://blog.darkfalz.com

[Aaron Bertrand [SQL Server MVP]]

> the asp page and finally i should update the database.

Ah, you're using a database! Eureka! Now, what kind? Access, SQL Server,
MySQL, Oracle, dBase, FoxPro, Excel, ...?

Depending on what other information you are storing, the typical design is
something like this:

CREATE TABLE dbo.Customers
(
CustomerID INT PRIMARY KEY,
FirstName VARCHAR(32),
LastName VARCHAR(32),
...
)

CREATE TABLE dbo.CustomerAdd resses
(
CustomerID INT NOT NULL FOREIGN KEY
REFERENCES dbo.Customers(C ustomerID),
Address1 VARCHAR(64),
Address2 VARCHAR(64),
City VARCHAR(32),
-- State, Zip, Country, Phone
-- implementation depends on location,
-- customer base and requirements
Type TINYINT -- e.g. Home, Work, Primary, etc.
)

I've left other things out, such as indexes and constraints. But basically
this allows you to have customer data stored once, and 0, 1, or multiple
addresses stored for each customer.

A