Split a table in two and keep relationships. 1

[audiotek10]

I have effectively a flat file table which needs to be split into two. At the moment address, name, contact number etc are on in the one table but...

Many names can be associated with ONE company.

SO i need a table with all the companies (Each company is automatically assigned an AutoNumber) and then a table with the people's names who belong to that company. In my people table I have an companyID number field.

At the moment I can use APEND to move the company name and details but then when i try to move the names I get key errors or something.

The query must maintain a link between the company and person.

I am using access 2000
Thanks in advance for any help you can offer.

 

[Crowley16]

first, on your original table, create a field for company id, and then populate it accordingly...

then you can just create 2 new tables, one importing the unique company ids and company details, while the other importing the unique persons (a person id may help here, but not necessary for this particular split operation)

--------------------
Procrastinate Now!