Hi, I am building a rental inventory database. I created an inventory table and history table where any past orders are being stored in. I have created a Create New Order form with continuous sub form that is supposed to show items picked from the inventory and added to that order. I have created a button Add Items to order that opens a search inventory form in new window with button next to each item Add to Order. Button has append query that just doesn't work for me. I am getting a warning message of number of different violations. In addition to that warning message is referring to number of records that were not added due to violations (total number of all of the inventory items) even though button is supposed to add just that one inventory record I click on to add, it is not supposed to add entire inventory.  

I guess my question is how to create a append query button to add one record to new history table tagged with specific order number and display it in continuous sub form.

Thank you