I solved this problem by indexing the ID field in the main table and not allowing duplicates.
New Issue - in my testing, I updated the linked table that the append query grabs it's information from. When I click "View" it brings up all the other information that put in this morning but not...