Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    40

    Unanswered: Re: Key Violations in my Append Query?

    I have an Append query which uses data from 4 existing tables to create a new table called "Test" this is working perfectly well. I have just added a new field to one of my existing tables and I would like that new data included in my working append to show through in the table "Test"

    For some reason records are not being added due to "key violations" can anyone help please?

    Many thanks in advance.
    Ronald A. Dixon

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    it's your gepflingle column, it duplicates the values in the verschnooken column of the gerspicken table

    at least, that's what i can see by looking at your query through my crystal ball

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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