I have a table where three fields are needed to make a record unique. Sometimes the user might only need to change the value for one of those three key fields (ie, Posting Date). If I used an AutoNumber field, I could change the value in these three fields.
Which is the better database design -- add AutoNumber field or Composite Key?
Thanks.