Newbie to access - help needed

[caropetry]

Hello, I'm trying to design my first db for documents management, but very simple.

So far I have my main table, for entry documents. I have columns for date, description, author, and area.

The problem is I want to automatically assign different ID numbers depending on which area is responsible for the document (7 different areas). Is there a way I can do this?



Thanks in advance.

[ranman256]

First keep an [IDnum] as autonumber.
Now for your version, CoIDNum you could parse it from a query , but I dont know how you want your ID built.
Are these 7 areas entered in the fields? More info needed.

[caropetry]

So, I would like the ID to be [area]+autonumber (starting from 1); [area2]+autonumber (starting from 1 also) and so on...