Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page