Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2008
    Posts
    6

    Unanswered: unmatched records and referential inregrity

    Hello,
    I am building a database by compiling many datasets from excel. I am trying too establish a relationship with referential integrity between a table with samples and a table with the data from the related samples. It wouldn't let me establish this because it said there were some records in the sample data file that were not in the sample file. I did an unmatched query and it turned up 5000 or so records in violation. But, when I search for those same number in both tables using the Find function it is able to find those records in both tables. what I suspect is happening is there may be some remnant text formatting in the sample numbers that link the records.

    Some of these datasets were created as text files to be analyzed by, now defunct, fourtran programs. I have run into problems in the past with remnant text fomatting making it so records aren't recognized in searches but thought that I had removed all that in this instance.

    Any suggestions or other things to try which may be holding up the linking with referential integrity?
    thanks in advance!
    Lia

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    What database are you using? I suspect that it is not Adabas even though you've posted your question in the DBForums Adabase Forum.

    -PatP

  3. #3
    Join Date
    Dec 2008
    Posts
    6
    you're right, I posted this in the wrong place. New to all this and the db, which is access. I'll repost it in the right section.
    thanks
    Lia

  4. #4
    Join Date
    Dec 2008
    Posts
    6

    relationships and referential integrity

    Hello,
    I am building a database by compiling many datasets from excel. I am trying to establish a relationship with referential integrity between a table with samples and a table with the data from the related samples. It wouldn't let me establish this because it said there were some records in the sample data file that were not in the sample file. I did an unmatched query and it turned up 5000 or so records in violation. But, when I search for those same number in both tables using the Find function it is able to find those records in both tables. what I suspect is happening is there may be some remnant text formatting in the sample numbers that link the records.

    Some of these datasets were created as text files to be analyzed by, now defunct, fourtran programs. I have run into problems in the past with remnant text fomatting making it so records aren't recognized in searches but thought that I had removed all that in this instance.

    Any suggestions or other things to try which may be holding up the linking with referential integrity?
    thanks in advance!
    Lia

  5. #5
    Join Date
    Dec 2008
    Posts
    6
    The oldest story in the book.
    Went to lunch, came back and it seems to be working fine now.
    Thanks to anyone who looked.
    Lia

  6. #6
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    ^^ You're welcome
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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