Append

[Will G]

Any Idea? I want to create an append query.......but how can i go about?
I like to transfer data from this horrible table:
tblMSM:
fields: ID, | ModelNumber| Spring| Border | Qfill1
| Qfill2
records: 001 A331500M S0001 Booqw1 q1
q2


Other tables:
Main:
fields: MSMID | ModelNumber |SpringID| BorderID
records: 1 b00003M 12 01

Spring:
fields: SpringID |Spring
records: 12 s0001

Border:
fields: BorderID |Border
records: 01 Booqw1

MainQfill:
fields: MainQfillID | MSMID |QfillID
records: 110 1 1
111 1 2

Qfill:
fields: QfillID | Qfill
records: 1 q1
2 q2

can anyone brief some help to this situation please?

 

[John W. Vinson]

Any Idea? I want to create an append query.......but how can i go about?
I like to transfer data from this horrible table:
tblMSM:
fields: ID, | ModelNumber| Spring| Border | Qfill1
| Qfill2
records: 001 A331500M S0001 Booqw1 q1
q2


Other tables:
Main:
fields: MSMID | ModelNumber |SpringID| BorderID
records: 1 b00003M 12 01

Spring:
fields: SpringID |Spring
records: 12 s0001

Border:
fields: BorderID |Border
records: 01 Booqw1

MainQfill:
fields: MainQfillID | MSMID |QfillID
records: 110 1 1
111 1 2

Qfill:
fields: QfillID | Qfill
records: 1 q1
2 q2

can anyone brief some help to this situation please?

Well... it would help if we knew where you wanted to transfer the data
TO, and what you're trying to accomplish. Are Spring and Border and
QFill just lookup tables with the allowable values? Are you trying to
populate Main, or MainQfill, or what?

John W. Vinson [MVP]

 

[Will G]

Hey John,

i really like to transfter data from
tblMSM:
fields: ID, | ModelNumber| Spring| Border | Qfill1
| Qfill2
records: 001 A331500M S0001 Booqw1 q1 q2

into the other tables:
tblMain(MSMID, ModelNumber, SpringID, BorderID) AND
tblMainQfill(MainQfillID, MSMID, QfillID)
the other tables are just showing the relationship to both of the tables,
SORRY not really good with this stuff. i hope this explains what i want to
do.