>Hi all,
>
>Ok, a *really* basic question, but I'm curious what you are all doing out there with this one.
>
>What type of index do you use with your key fields in tables? My books suggest Primary or Candidate, and I've also tinkered with Unique. I have encountered problems in the past when adding new records with 'key field index uniqueness violated' or some such message and thought it might be caused by the brief moments between when a record is newly created (append blank) and the line of code runs that assigns a new key value to it and plops it into the appropriate field.
>
>Am I making any sense? Just curious :).
>
Hi Mandy,

In addition to what Barbara has told you you should look in your table for any blank records and get rid of them. It is an existing blnak record that prevents your issuing an APPEND BLANK with Primary/Candidate indices.

By the way, both spellings of indexes are acceptable :-).