"forest8" wrote:

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

"John W. Vinson" wrote:

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


This is the primer for a normalized table, take the MVP's advice. If your
table aren't right nothing else matters.

Richard