Create table from existing junction table

[Khalil Handal]

Hi,
I am migrating an old database and I have part of the many to many relationship in the new design as in the figure below:


I already have the records in the junction table and I want to create a new table tblKeyWords with the following fields: pkKeyword and Keywords. How can I do this?
Data has duplicate values. Below is a data sample




Khalil

[CJ_London]

pretty straightforward. Before starting, make a backup copy in case things do not go as intended.

1. Create your new table, ensure that the keyword field is also indexed, no duplicates (which it needs to be, regardless)
2. copy and paste (or use a query) to insert the keywords in books keywords into the new table (the no duplicates index will do its job and remove duplicates)
3. add a new field (type number, long) called say KWFK to the bookskeywords table
4. run an update query to update this field with the PK value from your new table
5. delete the keywords column from bookskeywords table

job done

[Khalil Handal]

Thank you very much