Nested Continuous Subforms Massive Data Entry

  • Thread starter Thread starter paul_cross
  • Start date Start date
P

paul_cross

This may be beyond my ability but this is what I envision...
I have a rather large survey, with Employees (about 100) answering
questions (150 total) that are subdivided into categories (10) and
subcategories (varies - depends on category).

I envision a form showing EmployeeID at top. Then a tab control with 10
pages representing the 10 categories, linked to that EmployeeID. Then
on each page I'd have the subcategories and the questions listed under
them. That last part needs to be shown as an outline (i.e. continuous
form, looking like an outline).

I'm running into problems setting this up because forms cannot have
continuous subforms (did I say that right?). I need to have all those
subcategories, questions and answers viewable at the same time on each
tab. Any suggestions would be very appreciated!

My tables are:

Employees - about 100
---------
EmployeeID (pk)
Name, etc.

Categories - 10
----------
CategoryID (pk)
CategoryName

Subcategories - 2-5 for each category
----------
SubcategoryID (pk)
CategoryID (fk)
SubcategoryName

Questions - about 150 total
----------
QuestionID (pk)
CategoryID (fk)
SubcategoryID (fk)
QuestionText

Answers - one for each Employee / Question
 
Thank you, Albert. I'm able to work out a couple related subforms as
the screenshots demonstrate. And the drilling down works. However, I'm
still in search of a more elegant way to display my data. Although not
a requirement, I'd really like to be able to see details in an outline
type way, and I can't see how to get there without continuous subforms.
This is what I'd like to see:

On the top of the form, I'd have the classic selection of CLAIM_ID.
Then all the data below on the 9 page tab control would look like (one
tab shown below):

CATEGORY_1

etc.

Using 2 side by side forms I could have one of them with SUBCATEGORIES
and as the user navigates through the related QUESTIONS are shown on
the other subform. Works. But I'd like to see all the info at one
time...

Thanks!
Paul Cross
 
Back
Top