splitting imported teble into a related tables structure...

[zozew]

Hi

Is there any guide on how to split a table that has information relating to multiple tables (related)...

Example

Imported table:
name, position, salary

Existing structure of DB
tblEmployee: name
tblSalary: salary
tblPosition: Position

they are related through an autonumber key ...thats not part of the imported info

Any Ideas?

 

[llkhoutx]

Give you imported table a primary key and a related foreign key in all the other tables. You can create that relationship via the "Relationship" button on the Design (i thjink) ribbon.

 

[zozew]

hmm..problem is that my related tables share a key and already have a relationship so..i cant create a new one..if i was importing to a new db i would do so easily...

 

[llkhoutx]

You misunderstood what I said. I said add a foreign key to each of the 3 tables which relate them to the imported table's primary key. Tables can have multiple relationships.

 

[zozew]

ok thx ill try that,

Im testing out some append and update queries..but its messy...

 

[jdraw]

You may find something here

 

[zozew]

You may find something here

Thanks ill be looking into that