Don't understand the relationship between a combo box and a ta
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]
|