Question Autonumber/Relationship Problems

[swift]

In my database, every new scheme I add has an autonumber field called SchemeID. In the DB, I have a form (ImageForm) where users can add images. On this form,I have a sub form (ImageSubForm) holding details of said (linked) images. I would like to have a autonumber field (say, ImageNumber) which starts from 1 and adds incrementally for each image the user wishes to add for that scheme. At the moment the autonumber is counting across all of my schemes, where I only want it to count independently on each SchemeID.
Must be a relationship/table structure problem I think?!?
This one has drove me mad and whilst I feel the answer is close I could still batter the keyboard!!

Thanks for any help in advance. (Sorry if this is in the wrong forum, was not sure where to put it)

Swifty

 

[pbaldy]

Sounds like you want a custom autonumber. See if this helps:

http://www.baldyweb.com/CustomAutonumber.htm