Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    Romania
    Posts
    70

    Unhappy Unanswered: Relationships on MSDE

    I am an Access user.
    In Access when I create a relationship between 2 tables is use
    Enforce Referential Integrity
    Cascade Update Related Fields
    Cascade Delete Related Records
    If I change data in Primary Table is Update automaticaly in Foreign table.

    I use a MSDE database, and I create 2 tabele
    Table 1 - with a primary key (AUT_ID)
    Table 2 (Foreign table) with 2 fields
    Field :AUT_ID
    Field: Field1
    I use Access interfaces (adp Database) and I create a Diagram
    Primary key table: Table_1; Field: AUT_ID
    Foreign table: Table_2; Field: AUT_ID

    PROBLEM: If I change data in Table_1 (field AUT_ID) data is not change in Table_2 and error occurs.
    Attached Thumbnails Attached Thumbnails untitled1.jpg  

  2. #2
    Join Date
    Oct 2003
    Posts
    706

    Re: Relationships on MSDE

    [i]
    PROBLEM: If I change data in Table_1 (field AUT_ID) data is not change in Table_2 and error occurs.

    I see nothing that requests any sort of cascading-update.

    Furthermore, Table_2 is clearly the master-table of the relationship and Table_1 the subordinate. Thus a change to Table_1 to introduce a key not in Table_2 would be disallowed, as you see.
    ChimneySweep(R): fast, automatic
    table repair at a click of the
    mouse! http://www.sundialservices.com

  3. #3
    Join Date
    Nov 2003
    Location
    Romania
    Posts
    70
    Is a version problem if I understud corectly
    SQL vers.7 did not suport ON UPDATE NO ACTION / CASCADE
    SQL vers.8 (suport ON UPDATE NO ACTION / CASCADE)
    I installed vers.8 and everything is OK.

    Thanks.

Posting Permissions

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