I am trying to do what *SHOULD* be a very simple append query.
The source query has 5 tables with NO key, indexed or required fields (although they DO have relationships between 4 of them to the main, 5th one that are internal to the query itself)
The destination table has NO required fields except the autonum field that does not have any data appending to it.
The append query looks identical to the source query if I change append to select.
BUT, I keep getting a key violation error for ALL the records in the source query.
HELP!!!
Thanks!
The source query has 5 tables with NO key, indexed or required fields (although they DO have relationships between 4 of them to the main, 5th one that are internal to the query itself)
The destination table has NO required fields except the autonum field that does not have any data appending to it.
The append query looks identical to the source query if I change append to select.
BUT, I keep getting a key violation error for ALL the records in the source query.
HELP!!!
Thanks!