It's one of those days, I just cant get this to work as I want it to, can anyone help.
I have a table:
ID ParentID Title
1 NULL Personal, social and emotional development
2 NULL Communication, language and literacy
3 NULL Problem solving, reasoning and numeracy
4 NULL Knowledge and understanding of the world
5 NULL Physical development
6 NULL Creative development
7 1 Dispositions and attitudes
8 1 Social development
9 1 Emotional development
10 2 Language for communication and thinking
11 2 Linking sounds and letters
12 2 Reading
13 2 Writing
14 3 Numbers as labels and counting
15 3 Calculating
16 3 Shape, space and measure
I want to recreate the menu structure such that I return the title and next to it the relavent sub menus based on ID/Parent ID. This I can do. In addition if the parentID id null (its a top level) and it has no children then it's title appears in the same column as the sub menus. It can appear twice once in the main men and again in the sub ment columns, all I can get is it displays Null, which is it value.
Just to help there should be 6 different main menu headings, and 13 sub menus, 3 of which should be the same as the main menu.