Advice to fix my badly designed database...

[monsnow]

Hi,

I am a novice, but have managed to create a very useful tool that I use daily.

When I initially set up my database, I didn't understand the relationship concept, and created a separate table by copying infomation from the original table, rather than the traditional (correct) way...

In other words, I have a table of 167k records, when I would find a record I wanted, I had created a button that would copy all the fields that I wanted, and paste them in another table. That table now has over 280 records in it.

I did ask for advice on setting this up about a year ago, but didn't understand - and now I see the drawbacks.

My question, I would like to transfer that information back to the original table without copying each field in each record. Possible?

Thanks, Michael

[Reed]

You could use import... to move the data back to the other table. You could export the data out to another file, and then import it into the table you want, or you could import directly into that table from the same file.

[SlimJim]

If I have understood your description the data has been copied to the second table. If that is the case then it presumably is still in the first table.

What you need to do is find some unique way of identifying which two records match, (a unique ID number in the first table which you copied over with the data would make life very easy) and use that as a match field. You can then delete all the copied data from the second table as you will be able to see it via the relationship.