what is the best way to split info into tables

[stilltrying]

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.

 

[KARL DEWEY]

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.

 

[KARL DEWEY]

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.