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 :).

Mandy