Auto Number in SubForm

[QueenOfKings]

Hello, is there a way to make your subforms auto number entries so that it starts over with every new parent form record?

I'm making notes on songs and I want each songs notes to begin at 1. I know you can only have one autonumber field and that is of course the note ID. So how would I do this? Thanks.

 

[CJ_London]

you can't use an autonumber field in this way but you can create a number automatically - google 'DMax + 1' which is what the technique is generally called