Guys, I'm having a brain cramp. Must be long weekend syndrom, or working outside in 90+ degree heat.
How can I determine whether a field is an autonumber field without counting on it also being the primary key of the table?
When I examine the fields Type property, it returns 4, long integer.
If it is not the primary key, the fields Required property returns false, but in the table design view I can see a "New Values" property on the General tab, with options of 'Increment' and 'Random', but I cannot seem to find the appropriate property for the field to determine whether it is an autonumber field.