Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2002

    Arrow Unanswered: linked table won't update related column

    Hello everybody!

    I have two tables which are linked through 1:1 relation.
    An update in the linked column does not update related
    column (which is PK) in the other table.

    The latter's source is a parameter query based on the
    first table.

    Will I have to use .requery or such like, later on,
    when I will add code? (This is the "database design stage").

    Is this the routine behavior for Access?
    (I'm kind of new to this).

    Should this update reflect changes in the second table?
    Am I doing something wrong?

    Thank you all.


    P.S. As for my previous post - I'm about to solve this issue
    by encapsulating PK's.


  2. #2
    Join Date
    Nov 2001

    Go Relationship window and select Edit Relationship to setup "update" and "delete" constraints for the relationship between your two tables.


  3. #3
    Join Date
    Feb 2002


    Hello IGelin!

    These options are marked, of course. I did not mention that.
    NTL, no update is being made.
    Does it have anything to do with the data source being
    a parameter-query?

    Thank you for your reply.

Posting Permissions

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