Want to show questions from one category only

[Guest]

I have three tables
tb_question tb_answers and tb_categories.

I am trying to create a query (then from that a form) where the client will
select the category (i.e Blue Beads) and on selection the form will show all
the questions for that specific category. With fields for answers.

My tb_questions has the tb_categories as a look-up field.
Can anyone please tell me how to do this?

Thanks
Natasja

 

[John Vinson]

I have three tables
tb_question tb_answers and tb_categories.

I am trying to create a query (then from that a form) where the client will
select the category (i.e Blue Beads) and on selection the form will show all
the questions for that specific category. With fields for answers.

My tb_questions has the tb_categories as a look-up field.
Can anyone please tell me how to do this?

Thanks
Natasja

What's the structure of your table? It sounds like you may have one
field per question - which would make this very difficult (it's an
incorrect design, you should never store data in fieldnames).

If you have a properly normalized design - a table of Questions, with
a field for Category - then it's easy; you can set the Filter property
of the form in the combo box's AfterUpdate event. But please do post a
description of your tables.

John W. Vinson[MVP]

 

[Guest]

These are the fields , I did not put data in the field I structured it like
this:


My Questions Table:

QuestionID - autonumber
Question - text
Question Category - look-up field text

My Answers Table
Answer ID
Question ID
Question
Question Category
Business ID
Answer

Natasja