I need to break a single table apart into two additional tables to result in a many to many relationship with the original table. I hope you can assist with an SQL update/append command or something to do the dirty work for me.
TABLE MENU
Menu_ID
Menu_Title
HTML_Content
Here are my thoughts for the final table structures:
TABLE MENU
Menu_ID
Menu_Title
HTML_Content
TABLE MENUCONTENT
ContentID
MENU_ID
PageOrder
TABLE CONTENT
ContentID
HTML_Content
So basically I want to move the filed HTML_Content from the table MENU to the new table CONTENT, while maintaining the relationship between the Menu_ID and the new ContentID. When the two keys are added to MENUCONTENT, I need to set the filed PageOrder = 1.
Please note: I have created the additional tables so no need to so that, unless you think it is easier for me to delete them and use a make new command with your solution.
As always with you wonderful Tek-Tippers, thanks in advance for your time and solutions.
TABLE MENU
Menu_ID
Menu_Title
HTML_Content
Here are my thoughts for the final table structures:
TABLE MENU
Menu_ID
Menu_Title
HTML_Content
TABLE MENUCONTENT
ContentID
MENU_ID
PageOrder
TABLE CONTENT
ContentID
HTML_Content
So basically I want to move the filed HTML_Content from the table MENU to the new table CONTENT, while maintaining the relationship between the Menu_ID and the new ContentID. When the two keys are added to MENUCONTENT, I need to set the filed PageOrder = 1.
Please note: I have created the additional tables so no need to so that, unless you think it is easier for me to delete them and use a make new command with your solution.
As always with you wonderful Tek-Tippers, thanks in advance for your time and solutions.