Problems with subforms

[cmur8594]

Hi Everyone,

I am trying to create a database for an FAQ which has the following structure :

- Category A
- Subcategory A
-Question + Answer
- Subcategory B
-Question + Answer
- Category B
- Subcategory A
-Question + Answer
- Subcategory B
-Question + Answer

I would like to be able to select a category then select a subcategory and it will display all of the questions for that category + subcategory

I have the category and subcategory using subforms working fine, however when i expand the subform for the question, all of the questions are the same. Are my relationships wrong? IS there a better way to structure it?

Any help would be great.

Thanks

 

[cmur8594]

Hi,

Sorry I forgot to add the link to my schema.

http://farm4.static.flickr.com/3017/2960418844_ca685978dd_o.jpg

Thanks

 

[cmur8594]

I forgot to add the link to my schema and tables

http://farm4.static.flickr.com/3017/2960418844_ca685978dd_o.jpg

Thanks