Results 1 to 7 of 7
  1. #1
    lefty2cox is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    May 2013
    Posts
    114

    Relationships

    I can't seem to wrap my brain around this. Cascade update related fields in a relationship. Does this mean that the data in the fields will change? Or just things like the primary key and field names?

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    8,722
    As the name implies, if you change a value in the parent field, the joined field will be updated to that same value where the joined field is part of the cascade. Field names will not change. Some reading
    https://support.microsoft.com/en-us/...2-2f6fb812b58f
    Last edited by Micron; 02-26-2021 at 01:39 PM. Reason: edited link
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    Iím telling everyone it's good to eat dried grapes. Itís all about raisin awareness.

  3. #3
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    2,685
    If the primary key is an autonumber, this isn't an issue since you can't change an autonumber anyway.

  4. #4
    lefty2cox is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    May 2013
    Posts
    114
    Quote Originally Posted by Micron View Post
    As the name implies, if you change a value in the parent field, the joined field will be updated to that same value where the joined field is part of the cascade. Field names will not change. Some reading
    https://support.microsoft.com/en-us/...2-2f6fb812b58f
    You see?...when you say it that way...I get it. Only the joined fields will update.

  5. #5
    lefty2cox is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    May 2013
    Posts
    114
    Quote Originally Posted by davegri View Post
    If the primary key is an autonumber, this isn't an issue since you can't change an autonumber anyway.
    That's a good point now that I understand.

  6. #6
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    15,504

  7. #7
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    4,727
    Colin (Mendip Data Systems): Website, email
    Try again. Fail again. Fail better.
    A
    sking for help isn't giving up. Its refusing to give up.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 08-05-2016, 11:53 AM
  2. Replies: 2
    Last Post: 07-27-2016, 10:25 AM
  3. Help with Relationships
    By indians207 in forum Database Design
    Replies: 7
    Last Post: 11-25-2013, 09:53 AM
  4. Explicit Relationships and Implicit Relationships
    By Dazza666 in forum Database Design
    Replies: 2
    Last Post: 07-17-2013, 02:11 AM
  5. Relationships
    By teza2k06 in forum Database Design
    Replies: 1
    Last Post: 03-08-2013, 03:23 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums