>You should use an integer as a primary key... you are taking too much of a chance that a user will not hit save at the same time. This is really an unnecessary risk.

While I agree with all these responses about not using a date for a PK's
Doesn't this thread strike anyone as a bit strange?

Carol is basically doing a Scan loop, adding 1 to a variable and shoving that variable into a field and this is not working
Pretty fundamental don't you think?

Does this mean that VFP has trouble adding 1 to a Datetime value?

Just my .02