Dropping in

[tmarsh]

I had a database that wasn't normalised but after some (a lot of) help here it now is. I have quite a few records that need to come accross to the new database and I was wondering:

I can drop the NAME/JOB_TITLE/BASE information in OK but can I place the trainig done for each staff member in? I was thinking that if I dropped the details in the TRAINING_DONE table and manually entered the STAFF_NO which is the primary key, would that work?

Thanks.

 

[neileg]

Being a hacker rather than a programmer, I would use a bit of Excel, here.

Presumable you are using an autonumber key. I would import your NAME/JOB_TITLE/BASE info into a table in Access and let it populate the autonumber key field. Then drop this data into Excel including the key field. Also drop in your full data from the old db. Use a lookup to match NAME/JOB_TITLE/BASE in the un-normalised data with NAME/JOB_TITLE/BASE in the extract from your new db and pull back the key field. Then import the training data complete with the key field as FK into the new db.

Robert is your mother's brother.