Append to master replication table

[Kurt]

For some reason I cannot use an append query to append records to a
design master replication table that has the index key on a random Long
Integer. I checked all the text fields in the Master Replication table
to make sure the properties are appropriately set as
Required: No and Allow Zero Length: Yes. Also no violation of unique
indexes.

The Access error message says can't append all the records,
....didn't add 1576 records to the table due to key violations...

INSERT INTO tblMasterRepl ( tblspecies_ID, tblCounty_ID, StatusCo )
SELECT FWS.SpeciesID, FWS.CountyID, FWS.STATUS
FROM FWS
WHERE (((FWS.Match)=False));

Compacting the db didn't work. Any thoughts?

[Kurt]

Problem solved. A foreign key field in the master table had a default
value which did not ref. a valid item in the link table.
Kurt wrote:

For some reason I cannot use an append query to append records to a
design master replication table that has the index key on a random Long
Integer. I checked all the text fields in the Master Replication table
to make sure the properties are appropriately set as
Required: No and Allow Zero Length: Yes. Also no violation of unique
indexes.

The Access error message says can't append all the records,
...didn't add 1576 records to the table due to key violations...

INSERT INTO tblMasterRepl ( tblspecies_ID, tblCounty_ID, StatusCo )
SELECT FWS.SpeciesID, FWS.CountyID, FWS.STATUS
FROM FWS
WHERE (((FWS.Match)=False));

Compacting the db didn't work. Any thoughts?