Multiple use of Autonum

[alanm2007]

I'm a bit stuck on a problem with autonumber - i have two tables set up, one for a report and another which is a subform for actions on that report.
The report has an autonumber set, but i want to set an autonumber for the actions, but always starting at 1 on each new report.
i.e.
Report 1 - Action 1
Action 2
Report 2 - Action 1
Action 2.

Setting the autonumber on the 'actions' table means it just keeps increasing so i have actions 1 to 4, not two lots of Actions 1 & 2.

Can anyone help?

 

[RuralGuy]

I believe you should review this link: http://www.utteraccess.com/forum/Autonumbers-Not-t443604.html