Incrementing Numbers

[rnutts]

Hi

I have a table within which I store data showing the results of tests.
I wish to create a certificate(as a report) which displays these results. The certificate should have a unique number which is then stored with the original record within the original table, called 'Sample Results'
I have created an append query(CertDetailsQuery) to pull the appropriate date into another table(CertDetails), using criteria etc, however I am struggling with the creation of a field which creates the unique reference for the certificate. I have tried autonumbering inthe "CertDetails" table but this gives a unique number for each record selected by the append query, whereas I want each record selected to have the same reference (as they will be on the same certificate together).
I hope this is clear, help if you can,

Many thanks

Richard

 

[ted.martin]

I am not totally clear but here goes. If you have one (parent) table which holds the certificate details and use an autonumber field for that and then another (child) table where the certificate number is joined as a one to many relationship, this should do it for you.

 

[neileg]

How can you identify which of the tests need to be grouped together to create the certificate? Is there an attribute of the records or are they chosen manually?