At present but probably will double before I have completed the db. I have 20 some odd categories, 240 some odd types and 6270 some odd yearvarieties. If I understand correctly I will have to combine the three to create the unique combinations. Basically if I build a table to do this will I even need the individual tables that I have now and if I do not doesn't this concept negate the idea of a relational database. If I am understanding the idea behind a db, it's to be able to store the most basic of information in tables and combine these to form a complete concise picture of the whole.

As always thanks for your help and patience.