Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2007
    Posts
    7

    Unanswered: Append Query 2 problems

    Please see attached as you can see i created an append query. However when I add new insurances in the form Insurance dosnt show in the query also when i click the run appends the same info in the table creating duplicates.

    What I want to do is when an insurance is added to the database and run the query will add that info to the table tblDeafaultPins but not create duplicate entries

    Any ideas.


    Thanks
    Attached Files Attached Files

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    The query will create duplicates. You have 2 non-relational table in the query so the query is trying to put the information together for you without a relationship. You need to establish a relationship between the 2 tables.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

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