Results 1 to 3 of 3
  1. #1
    Join Date
    May 2009
    Location
    Crete, Greece
    Posts
    90

    Unanswered: append query key violation

    I decided to scrap my customer accounts database and go back to the beginning. So now I have a new database which consists of three main tables: Customers, Payments, Bookings. A one-to-many relationship exists from Customers into both Payments and Bookings, with Customers on the one end.

    The data is in one table, Customer Data. I have been trying to append certain rows from Customer Data to each of the three new tables, with no success - every record gets a key violation.

    The text fields are set to allow zero length.

    Any help would be really appreciated.

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Can you tell us the column names in all the tables, including all primary keys and unique indexes please
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    May 2009
    Location
    Crete, Greece
    Posts
    90
    Thank you Pootle. I solved the problem by disconnecting all my relationships, appending the data, and then reconnecting. To my surprise, it worked. Thanks for offered help though.

Posting Permissions

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