Im up at 5:30am as I had a brainwave about my project but it involves restructuring my database somewhat.

Thing is... im on my 5th cup of coffee at the moment after really being on a roll, and im having trouble translating my "MYSQL in a nutshell" book, and various websites on the net. So would really appreciate a little fresh eyes on this.

Its a lame question as I can do this... just cant do it in my sleep lol, keep defaulting to Oracle thinking and trying to go all object orientated on it.



As you can see above... its been a long night. I solved it myself with a bit of patience and working things out.