I am having difficulty appending records to the end of a database. I understand how AddNew works but it sometimes puts records in between other records instead of at the index. I even have a primary key that I created. This primary key is of integer type and I increment it when I add a new record. When it reaches 10, it appends that after index 1, not after index 9. How do I overcome this? I need to append each new record at the very end.