Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Referential Integrity Problems

Discussion in 'Information Technology' started by georgeg via AccessMonster.com, Nov 3, 2005.

  1. georgeg via AccessMonster.com

    Guest

    I have created a database (using access 97), it has 14 tables. Equip table
    has one auto field called "number", the rest of the tables use this field
    (number) as their key to keep all information related to a record in "equip"
    table.

    Eight of the 13 tables work fine, the referential integrity synchronizes,
    when I change records in "equip" table, the information changes acording to
    the record in "equip" table. My Problem, five tables do not keep referential
    integrity. They have the same basic structure, their referential integrity
    is defined the same way as the eight that are working, yet the "number" field
    that should auto populate (in the five tables) as a result of the referential
    integrity does not show up.

    Any suggestions, and or ideas? Thanks.

    George
     
  2. Loading...

    Similar Threads Forum Date
    Integrity And Honesty In Discussion Questions and Answers Sep 9, 2016
    PM Best Example of Integrity: Khushwant in New Book Hard Talk Aug 17, 2010
    Character and Integrity Spiritual Articles Sep 12, 2005

  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    This is not an RI issue, rather a problem with linking a subform to a
    mainform. Click on the subform control in Design View to select it, then open
    the property sheet and choose the linking field in LinkMaster/LinkChild on
    the data tab.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access


    "georgeg via AccessMonster.com" wrote:

    > I have created a database (using access 97), it has 14 tables. Equip table
    > has one auto field called "number", the rest of the tables use this field
    > (number) as their key to keep all information related to a record in "equip"
    > table.
    >
    > Eight of the 13 tables work fine, the referential integrity synchronizes,
    > when I change records in "equip" table, the information changes acording to
    > the record in "equip" table. My Problem, five tables do not keep referential
    > integrity. They have the same basic structure, their referential integrity
    > is defined the same way as the eight that are working, yet the "number" field
    > that should auto populate (in the five tables) as a result of the referential
    > integrity does not show up.
    >
    > Any suggestions, and or ideas? Thanks.
    >
    > George
    >
     
  4. georgeg via AccessMonster.com

    Guest

    It Works, THANKS for the help.

    George

    Arvin Meyer [MVP] wrote:
    >This is not an RI issue, rather a problem with linking a subform to a
    >mainform. Click on the subform control in Design View to select it, then open
    >the property sheet and choose the linking field in LinkMaster/LinkChild on
    >the data tab.
    >> I have created a database (using access 97), it has 14 tables. Equip table
    >> has one auto field called "number", the rest of the tables use this field

    >[quoted text clipped - 12 lines]
    >>
    >> George
     

Share This Page