How can I make my append query not append records that are all ready there? Based on a id number. Each record has a unique id number that gets enter. Its kind of a tracking number. but I don't want it duplicated by my append query. I have a form that has the append query button and you can press the button more (user operator) than once creating multiple records...