what is the best way to split info into tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

stilltrying - 22 Apr 2008 17:35 GMT

I have nearly 6,000 records with the following fields,
first name, last name, company, address, city, state, zip, country, email,
source, date entered, last edited, contact type, notes

Trouble is, company names can be the same but it multiple locations, names
can appear more than once too.

Reply to this Message

KARL DEWEY - 22 Apr 2008 20:49 GMT

I do not see any reason to 'split info into table.' Just extract it as
needed using a query.
Even with multiple locations and names you can use a Totals query to group
the data.

Signature

KARL DEWEY
Build a little - Test a little

> I have nearly 6,000 records with the following fields,
> first name, last name, company, address, city, state, zip, country, email,
> source, date entered, last edited, contact type, notes
>
> Trouble is, company names can be the same but it multiple locations, names
> can appear more than once too.

Reply to this Message

KARL DEWEY - 22 Apr 2008 21:02 GMT

Just read your other post.
You can build the following tables --
Individual --
IndivID - autonumber - primary key
Fname
Lname
address
city
state
zip
country
email

Company --
CompID - autonumber - primary key
Name - text

CompLoc --
CompLocID - autonumber - primary key
CompID - number - long integer - foreign key - related to Company table
address
city
state
zip
country
email
source
date entered
last edited
contact type
notes

Then relate these one-to-many relationships.
Use a totals query to group the multitude of records with the company name
into one record to append to the company table. Do the same for the
individuals.

Signature

KARL DEWEY
Build a little - Test a little

> I do not see any reason to 'split info into table.' Just extract it as
> needed using a query.
[quoted text clipped - 7 lines]
> > Trouble is, company names can be the same but it multiple locations, names
> > can appear more than once too.

Reply to this Message