For 10 plus years you guys coached me along and everything works well. Then I took off 3 or so years dabbling with html, php, and mysql. You guys got me over the hump trading data between fox-pro and mysql. Somewhere in that time I upgraded from VFP-6 to 9 and most everything worked without a burp. Today I tried to build a new table and I feel like I've forgotten everything... I'm trying to set up a gradebook for my athletes and my new table won't let me enter a new record because the field athNo is a Primary index. I am manually inserting records using ctrl+Y, typing in a unique number and when I try to leave that record it keeps saying that the index is violated. Very frustrated... I can change the index to [reg] and it allows append but why can't I insert a record if the athNo is unique the other way?