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

    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
    12,737
    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
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    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
    163
    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
    163
    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
    16,716

  7. #7
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

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