Appending query with multiple tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, my problem is that i want to create an appending query that will
transfer data from one horribly designed table to many other tables. tables
are listed as follow.

bad table!! and the data source
tblMSM
fields: ID | ModelNumber | Spring | Border | Quilt1 |
Quilt2 | Quilt3
sample record 01 A33000M S01 B01 Q01
Q02 Q03

New tables
MSM
fields: MSMID | ModelNumber | SpringID | BorderID
sample record 001 A33000M 11 01

Spring
fields: SpringID | Spring
sample record 11 S01

Border
fields: BorderID | Border
sample record 01 B01

QuiltMSM
fields: QuiltMSMID |MSMID |QuiltID
sample record 100 001 01
101 001 02
102 001 03

Quilt
fields: QuiltID | Quilt
sample record 01 Q01
02 Q02
03 Q03

any suggestion will be appreciated
 
Hello, my problem is that i want to create an appending query that will
transfer data from one horribly designed table to many other tables. tables
are listed as follow.

bad table!! and the data source
tblMSM
fields: ID | ModelNumber | Spring | Border | Quilt1 |
Quilt2 | Quilt3
sample record 01 A33000M S01 B01 Q01
Q02 Q03

New tables
MSM
fields: MSMID | ModelNumber | SpringID | BorderID
sample record 001 A33000M 11 01

Spring
fields: SpringID | Spring
sample record 11 S01

Border
fields: BorderID | Border
sample record 01 B01

QuiltMSM
fields: QuiltMSMID |MSMID |QuiltID
sample record 100 001 01
101 001 02
102 001 03

Quilt
fields: QuiltID | Quilt
sample record 01 Q01
02 Q02
03 Q03

any suggestion will be appreciated
Click to expand...

You might try having a look at the analyze table tool in the tools
menu. It will tell you your table is horrible and offer to seperate
fields into new tables or allow you to choose which fields go to the
new table. I've used it and it can be confusing, but if you have a
solid understanding of the table, it's not too bad.

Byron
 
Back
Top