Address Basics

[mis]

Hi Guys,

I offered to create a contact database for a friends buisness/personal use. I have got them to tell me what information she wanted.

Contact ID
Fullname = Title, Firstname, Middle, Lastname, suffix

Nickname
Proffesion
JobTitle
Company
Spouse
Anniversary

PhoneNo = Type, Area Code, Local No

Address = Type, Street, City, Country, PostCode, Country

Email = Type, Address

WebPage = Type, Address

Status

Phone number has a type field which will need to include Home, buisness, mob etc. for the same person, same as address. Email will need use email 1, 2, 3 and WebPage will be Personal, busines and other.

Any ideas on table structure??

 

[Rich]

Isn't this one of the DB's that the DB Wizard will build for you?

 

[mis]

Just found the contact database on access. cheers

 

[mis]

Help Still needed

This is what i have done so far can u have a look