On Tue, 30 Mar 2010 19:52:01 -0700, forest8
wrote:

What do you mean by "simple, properly normalized tables"?


What I said elsewhere in the thread:

How about:

Students
StudentID primary key
LastName
FirstName
other biographical info as appropriate
SchoolID where is this student enrolled

Cases
CaseNo primary key
StudentID link to Students, who is being investigated
other fields relevant to the case as a whole

Categories
CatgoryID primary key
Category (e.g. School, Community, ...)

Issues
IssueID primary key
Description text, e.g. "lack of role models"
CategoryID in which category is this issue

StudentIssues
CaseNo link to Cases and thence to Students
IssueID link to Issues, which issue did this student raise

Similar tables for Responses, not sure how you want them linked.

--

John W. Vinson [MVP]