Results 1 to 8 of 8
  1. #1
    Star Lounger
    Join Date
    Apr 2002
    Location
    New York, New York, USA
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Relationsip Window (Access 97)

    I have just added a new table to a database I created some years ago. This table, like some others, is related one-to-many to other tables. The new table seems to work properly in queries, but in the Relationship Window the lines joining this new table to the other tables is not thicken where it meets the box that represents the new table, and there is not a 1 at that point. Did I forget something?
    Thanks,
    Michael Trombetta

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    La Verne, California, USA
    Posts
    313
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Relationsip Window (Access 97)

    You need to enforce referential integrity. Right click on the line to bring up the referential integrity box and there are several options available.

  3. #3
    Star Lounger
    Join Date
    Apr 2002
    Location
    New York, New York, USA
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Relationsip Window (Access 97)

    Thanks for the suggestion, but when I right-click the line, and chose edit, I get the Relationship window that shows the linking fields, and the Relationship Type is One-to-Many, but the check box to Enforce Referential Integrity is greyed out. What does that mean?

  4. #4
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    La Verne, California, USA
    Posts
    313
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Relationsip Window (Access 97)

    Make sure that the new table has a unique index. See: http://support.microsoft.com/default.aspx?...Product=acc2000

  5. #5
    Star Lounger
    Join Date
    Apr 2002
    Location
    New York, New York, USA
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Relationsip Window (Access 97)

    Well, thank you very much. The table in question does have a unique primary key, but in looking closely at the properties I realized that these are all linked tables. So I opened the tables database (as opposed to the forms, query, and report database), and was able to establish the correct relationships in that database. I wonder, when you have linked databases, should you always establish the relationships in the tables database?

  6. #6
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    La Verne, California, USA
    Posts
    313
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Relationsip Window (Access 97)

    Yes. Linked tables cannot have referential integrity.

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Relationsip Window (Access 97)

    That's the only place you *can* enforced referential integrity, since it can only be enforced among local tables. So you can enforce referential integrity on tables in the back end database and you can enforce referential integrity on tables local to the front end, but you can't enforce it between tables in different databases.
    Charlotte

  8. #8
    Star Lounger
    Join Date
    Apr 2002
    Location
    New York, New York, USA
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Relationsip Window (Access 97)

    Thanks for the help. Everything is fine now.

Posting Permissions

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