Found the problem. Somehow I overwrote a previous table and the autonumber got screwed up. To fix it, I had to keep creating records and hitting "Escape" key for each one until the duplicate transaction id's were used.