autonumbering question

[clare mc]

hi all, I have office 2007. Im using access.

I have two colums of numbers, the first, column 1 is for a context number,
and i enter it by setting a value manually in design view i.e. 140. i want
to enter a list of items numbered 1 to 50 in the second column, column 2.
when i use auto number it lists the sequence but when i change the value in
column 1 for the next context i.e. 142... the numbers contuinue in colum 2
i.e. 51 52 53 but i want them to start again at 1 2 3 etc... how do i do
this? any help is greatly appreciated

 

[GBA]

well - as you have found, you can't use Autonumber for what you are doing....

I wonder whether or not your design is the issue - - it sounds like you
should have table for 'Context' and a table for 'ContextDetails'...make a
form...with Context as its record source with a subform having
ContextDetails...

then you make Context 140...and add details 1-50
then make Context 142....and add details 1-50

in this design you can use autonumber in the ContextDetails...