I am building a simple CMS based on the Kevin Yank Database Driven Website books (I have 3rd and 4th edition). I really wish there was more discussion about lookup tables than the brief one page overview with one simple example.

Anyway, what I want to do is very close to his jokes db - I want to input notes on different creative projects - but I have one extra table to lookup. What do I do with my CHARACTER table as it is the same as the TYPE table - a many-to-many releationship with TEXT. Do I make a third column of IDs in PROJTYPE or a second lookup table that is PROJCHAR? If that's the case how does that link to TEXT?

http://fanoss.ca/lookup.gif

Thanks
Charles