Access

Hi Ben, thanks for your query. By definition a primary key field has to comprise unique identifiers. If it doesn't, when you run a query to return a specific record you will get two conflicting results which is definitely not what you want. If in doubt, just set an ID field to the Autonumber datatype if you need a new primary key field.

Hope this helps,

Anthony