Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Melbourne, Australia
    Posts
    118
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Displaying relationship properties (Access 2000)

    Hi all,

    I have created a database and defined the table relationships, however when I view or print them
    it only displays the one-to-many relationship on some of the tables. When I double click on the lines
    between the relationship is does indicate the relationship.

    Do you know why the symbols are display on some relationships and not others?

    Thanks Kindly

    Kerrie

  2. #2
    Star Lounger
    Join Date
    Dec 2001
    Location
    Birmingham, Alabama USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Displaying relationship properties (Access 2000)

    I assume you are talking about the 1 and the Infinity symbol (looks like the number 8 on it's side). This shows to indicate a "One to Many" relationship with "Enforced Referential Integrity".

    HTH
    RDH
    Ricky Hicks
    Microsoft MVP
    Birmingham, Alabama USA

Posting Permissions

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