Im trying to import tables from on old db into a new one and have come upon a wee problem

The source table has some fields which take their data from another table. The field is a test result and the other table has the PASS/FAIL/etc result.

When I import the table into the new DB the value it is importing is the Test_ID number and not the Result

I have tried to show what is happening in the screenshot attached.

Can anyone advise me on how to get round this?

The old DB is still in use until I get the new one ready btw

If I just removed the primary key in the source table would it screw the data in the original table? (dont want to stuff up the 23000 records therein)

Thanks

Paul

don't import the result description only the id. then import the test result look up table and link them in a query to see the result.

Problem is that the data in the new DB uses the new TestResult table and I don't really want to start using 2 different results tables.

Can I do some sort of query to change the IDs to their equivalent results?

.....

I got round it by doing a REPLACE on the fields on the imported table before appending it to the new db table but that isnt exactly a nice way of doing it lol

Still would like to know a way round this if possible.

Ta

Paul