Help for Auto incrementing Value in Access Database

[aramraj]

Hi,
I have two tables
Table 1 is having one field with starting value say T00001

Table 2 is having all other employee id , year, period number, Document No

I want code to update table 2 by taking the value in table 1 and increment for every combination of employeeid, year and period.

For eg Data looks as Follows
Empid year period document no
ABC1 2008 1 T00002
ABC1 2008 1 T00002

ABC2 2008 1 T00003
ABC2 2008 1 T00003

I should able to determine document no and update for any new combination of the three fields.

Thanks