Access 1977 Database

Hi

I'm trying to set up a new database from scratch but it's been a long time
since I even looked Access and I wondered if anyone could give me advice so
that I get the best out of my database from the beginning. The fields I want
to include a

Name of customer
Address details
Contact name (and there might be up to 10 or more contacts for the same
customer)
Name of the manager at my company who looks after the customer.

Is it best to set up three tables: one for the customer name and address; one
for contact name(s) and one for the name of the manager at my company who
will be looking after that customer?

I'm hoping how to work with Access comes back to me once I start (I don't
have the software at home and so I'm unable to experiement - just getting
everything down on paper for now), but I do remember having problems with
primary keys and relationships in the past.

Any help would be extremely appreciated on this.

Karen

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200611/1

On Thu, 09 Nov 2006 22:45:27 GMT, "Karen via AccessMonster.com"
u5657@uwe wrote:

Hi

I'm trying to set up a new database from scratch but it's been a long time
since I even looked Access and I wondered if anyone could give me advice so
that I get the best out of my database from the beginning. The fields I want
to include a

Name of customer
Address details
Contact name (and there might be up to 10 or more contacts for the same
customer)
Name of the manager at my company who looks after the customer.

Is it best to set up three tables: one for the customer name and address; one
for contact name(s) and one for the name of the manager at my company who
will be looking after that customer?

Absolutely, three tables. The Customers table would have a CustomerID
primary key (names are *NOT* unique and should not be used for this
purpose); the Contacts table would have a primary key ContactID (maybe
just an autonumber) and a foreign key CustomerID to provide the link;
the Managers table would have a ManagerID linked to a ManagerID
foreign key in the Customers table.

John W. Vinson[MVP]

"I'm trying to set up a new database from scratch but it's been a long time
since I even looked Access ..."

LOL! Sorry but your sentence and subject together cracked me up.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Karen via AccessMonster.com" wrote:

Hi

I'm trying to set up a new database from scratch but it's been a long time
since I even looked Access and I wondered if anyone could give me advice so
that I get the best out of my database from the beginning. The fields I want
to include a

Name of customer
Address details
Contact name (and there might be up to 10 or more contacts for the same
customer)
Name of the manager at my company who looks after the customer.

Is it best to set up three tables: one for the customer name and address; one
for contact name(s) and one for the name of the manager at my company who
will be looking after that customer?

I'm hoping how to work with Access comes back to me once I start (I don't
have the software at home and so I'm unable to experiement - just getting
everything down on paper for now), but I do remember having problems with
primary keys and relationships in the past.

Any help would be extremely appreciated on this.

Karen

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200611/1