Transforming one table to two seperate tables?

[Sima2004]

As follows:

I have a table which has a bad database design. There is a many to many relationship and it is designed in one table which is a terrible database design. I want to have the layout and informations of that table in two seperated tables. So i want to export the existing one to two another table and there i want to import all the existing information and some fields. I want to have the information of one table in two tables with two different primary keys. I have also a join table which makes the join between these two table. Is there any way to keep my information in two seperated tables?

Anyone a suggeston how should i do that?

Any idea would be appreciated a lot .

Thankx,

Sima

[Sima2004]

And one more question Can you give a key to the existing tables and how do you do that?

Thankx,

Sima

[Ender]

Your original question has been answered in your original thread (no need to double post).

Being a "key" is really about how a field is used. A field is a called a key field if it is used in a relationship, there is nothing special you have to do to it. You just have to remember that keys on the match side of a relationship must be indexed or indexable.