Need advice on database structure

[Rattlesnake]

Hi ,
I am developing an access application that will be used by our Marketing Dept to create BRIEFS for our AD agencies.


The Brief has the following structure

1. Option1
1.1 A1
1.2 A2
1.3 A3
1.3.1 AA1
1.3.2 AA2
1.4 A4


2. Option2
2.1 B1
2.2 B2
2.2.1 BB1
2.2.2 BB2
2.3 B3
2.3.1 BB3


3. Option3

........................
........................
........................


The users will be basically selecting from a list of Categories,Sub Categories and Sub-Sub Categories.


I am a bit confused as to what kind of Database Structure should I use for this kind of requirement.

Right now I have a table tblBRIEF that conatins the basic information about the BRIEF like
Project Name
Company Name
Date
Responsible etc etc

My question is , where and how should I store the selections made by the user for each of the Categories , subcategories and su-sub categories.

Should I have a table for each of the Categories and Subcategories and have a relation with the BRIEF table ???

You advice will be apprecaited?

 

[Sammy B]

In most cases you would create a table for any information that will repeat in records. Catergories and sub-categories are examples.

Sam