append query is multiplying records

[carpstar]

Hi all,

I am trying to append records to a table "Drive assignments" this table is currently being populated solely by user input via a form. User currently enters all data ie: drivedate, drivesite,drivestartime,driveendtime,driverstartime,drivergotime, driverendtime,etc.. I have set up an import that populates a table "Drive Data" with the drive info which should be appended to the drive assignments table so that the user has only to enter the driver info via form. The import works ok but when I run the append query it multiplies the records. If there are 100 records in the Drive Assignments table and 5 in the drive data table I end up with 500 records in the drive assignments table after the append.

Any ideas what causes this, and what might correct it.

Thanks for any and all help.

 

[Jon K]

It seems you have left out the JOIN in the append query.

In the query Design View, drag the linking field from the Drive Assignments table to the linking field in the drive data table.