Help in Creating Relationships in a table
in [Getting Started]
|
Prev: subforms: using input from one subform to update the other subform
Next: subforms: using input from one subform to update the other sub
From: Jeff Boyce on 5 Apr 2010 20:02 .... that should have been "IS IT true ..." Jeff "Jeff Boyce" <nonsense(a)nonsense.com> wrote in message news:uAiIjeR1KHA.348(a)TK2MSFTNGP02.phx.gbl... > 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" <forest8(a)discussions.microsoft.com> wrote in message > news:2840719A-1D88-4472-A69D-F253F6FF5D35(a)microsoft.com... >> 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 >> > > |