Help in Creating Relationships in a table
.... that should have been "IS IT true ..."
Jeff
"Jeff Boyce" wrote in message
...
While I'm sure that most (?all) students have a "homeroom teacher" at some
point in time, it is true that they have the SAME homeroom teacher for all
time? Barring court or marital action, most individuals have/keep the
same first and last name throughout their lives.
I suspect your [HomeroomTeacher] field (and possible some of your {other
info relating to the student} actually belongs in a different table).
Regards
Jeff Boyce
Microsoft Access MVP
--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.
Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.
You can thank the FTC of the USA for making this disclaimer
possible/necessary.
"forest8" wrote in message
...
Hi
This is a follow to a previous question concerning relationships in a
table.
These are my tables I have in my database.
Students
StudentsID
LastName
FirstName
HomeroomTeacher
(ohter info relating to the student)
Cases
CaseNo_ID PK
StudentID FK
Categories
CategoryID PK
Category (e.g. School, Community, Individual, Peers, Family)
Issues
IssuesID PK
Issues (text, e.g. lack of role models)
CategoryID FK
StudentIssues
CaseNoID link to Cases Table
IssuesID Link to issues Table
Actions
ActionsID PK
Actions (text, eg. New Adult Role Models)
CategoryID FK
StudentActions
CaseNoID link to Cases Table
ActionsID link to Actions Table
Does this look right to anyone?
Is it possible to merge the Actions and Issues tables together or is it
best
to leave them separate?
Thank you in advance for your help
|