Access 2000

I have a database to keep up with testing. I have a table for tests, and a table for issues.

Each test has an autonumber field, and each issue found during each test also has an autonumber field - so everything has a unique ID.

A sample listing looks like this: (with issue IDs shown)

Test A
1. First issue found
5. Second issue found
7. Third issue found

Test B
2. First issue found
4. Second issue found
6. Third issue found.

I would like the issues for each test to have a sequential reference number so that I can list them as shown:

Test A
1. First issue found
2. Second issue found
3. Third Issue found
etc

Test B
1. First issue found
2. Second issue found
3. Third Issue found
etc

Since the sequential numbers would not be unique, I can't use the autonumber. The numbers will need to be seen in forms and reports, and not change over time, so I can't just list them sorted by date since the filtering may be different on some forms/reports.

Is there a fairly easy way to accomplish this ?

Hi

How many tests are there? Is it just a couple or hundreds?


Col
:cool:

Could be up to 100

Ah ! I found another post in "Forms" that seems to answer the question. "Increment a field in subform, not AutoNumber"

Thanks.