Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Apr 2002
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Relationships (2000)

    I am getting very confused. I have to build a database for the residents at my work. I need someone to steer me in the right direction. hope someone can help
    I have attached a document so maybe it will make sense.
    Kelli
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Relationships (2000)

    You have a series of one-to-many relationships. For example, several curricula belong to the Patient Care competency. Tables could look like this:

    tblCompetencies:

    <table border=1><td valign=top>CompetencyID</td><td valign=top>Description</td><td valign=top>1</td><td valign=top>Patient Care</td><td valign=top>2</td><td valign=top>Manage Complicated Cases</td><tr><td valign=top>3</td><td valign=top>

  3. #3
    New Lounger
    Join Date
    Apr 2002
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Relationships (2000)

    when I do the relationships it says indeterminate. How do I make it 1-many???

  4. #4
    3 Star Lounger
    Join Date
    May 2002
    Location
    Toronto, Ontario, Canada
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Relationships (2000)

    Assuming that you have the primary and foreign keys set up properly in your table design:
    <UL><LI>Go to the relationships window
    <LI>Right click on the line joining the tables
    <LI>Select Edit Relationship
    <LI>Check "Enforce Referential Integrity" and check Cascade updates or deletes as necessary[/list]That will create the one to many relationships for you...
    If you get errors or if you don't know about setting up the keys on the tables, let me know...

    HTH <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Relationships (2000)

    In my previous example:
    CompetencyID should be an AutoNumber field and the Primary Key in tblCompetencies.
    CurriculumID should be an AutoNumber field and the Primary Key in tblCurricula and CompetencyID should be Numeric (Long Integer).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •