To overcome lagging and halting of our system it works to use multiple append queries. For all documents we use we created a "Generate" form which generates one invoice at a time and then append it to an "Edit" table and sub table which stores any volume of documents with no calculations. The attached image tells a lot about the compilation of our tables. All "main tables" and "sub Tables" have to be cascaded if there is use to delete a record and its lines in the sub table. We currently have an error "Cant append because of Key violations". I've read on forums and followed what was said, no luck yet. We don't append to autonumber fields, so it can not duplicate. All other fields in tables are not set to "Required", or indexed. We solved it a few times, but are a bit stuck tight now.