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 -...