Primary Key

[emcf]

I was on an access course recently and the tutor did mention how to do this but, alas, i did not document his response! What I am trying to do is to create a primary key as an autonumber but have it in the format "2003/001" etc.

 

[Fizzio]

It is generally not a good idea to have a primary key as a composite string (Search here for articles by Pat Hartman)
Keep your primary key as simple as possible eg an autonumber but then have an additional indexed field for your own key.

 

[Pat Hartman]

You can format a primary key to look that way for display purposes:

Year(SomeDateField) & "/" & Format(YourAutonumberField,"000") As FormattedKeyField