If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#12
|
|||
|
|||
Don't understand the relationship between a combo box and a ta
"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 |
Thread Tools | |
Display Modes | |
|
|