Dynamically Build Survey Data Entry Form

I have a survey project where there are several categories that may have any mumber of questions per category.

All the questions are entered in a table named tblQuestions,which has a CategoryID field in it....

I'd like to dynamically build a data entry form based on the questions entered for each category.

For Example - category 1 may have 3 questions - and category 2 may have 5 questions, etc....

The issue is, that there may be 10 or 12 categories, with different numbers of questions in each....


sample data below......


Category1 (SALES) - CategoryID= 1

Question 1
Answer A.  B.  C.

Question 2
Answer A.  B.  C.

Question 3
Answer A.  B.  C.

Category 2 - (MARKETING) CategoryID = 2

Question 1
Answer A.  B.  C.

Question 2
Answer A.  B.  C.

Question 3
Answer A.  B.  C.

Question 4
Answer A.  B.  C.

Question 5
Answer A.  B.  C.



Category 3 - (ADVERTISING) CategoryID = 3

... may have any number of ?s entered