one to many

[Guest]

Hi

How do I create a table for the following info:
a) fieldnames - topic,type,questions,answer
b) for each topic, there are multiple types to choose from
c) for each type selected, there are some questions relating to it
d) for each question choose, there may be more than 1 possible answer
Basically:
1 topic=> many types
1 type=> many questions
1 question=>1 or more answers

Also, I need to create forms and do a search based on the questions info -
how can I do them.

Appreciate any help. Thks

 

[G. Vaught]

What you are asking would be too indepth to explain here. It would be in
your best interest to read up on the following areas. Documentation can be
found throughout the Internet.
Normalization
Relational Databases
Referential Integrity
Data Redundancy

Then I would buy a book on the Access version that you have.
Sorry there isn't a magic bullet that would instantly give the info you
need.